record printing

Post Reply
jfcorn
Posts: 6
Joined: Tue Dec 18, 2018 10:26 pm

record printing

Post by jfcorn »

I have a spreadsheet containing names, addresses,city, etc.
in columns a b c d e f g h
printing is fine however I would like to be able to;
print a b c then print d e f g h on the next line then go to the next record
for the whole sheet and repeat.
then each record would print as;
a b c
d e f g h

Does PM have the capability to do something like this?
thanks
JFC
Jossi
SoftMaker Volunteers
SoftMaker Volunteers
Posts: 1266
Joined: Fri Dec 05, 2003 10:47 pm
Location: Luebeck, Germany

Re: record printing

Post by Jossi »

Don't know if there is a way in PlanMaker, but when you import your database into TextMaker and use the label function there it should be easy (Insert > List/label...).
PeterC
Posts: 7
Joined: Tue Mar 13, 2018 6:10 pm

Re: record printing

Post by PeterC »

Your objective can be met fairly easily. Using an address table example of four columns (fields) entitled FN, LN, Address, and Synopsis. To create a cell with the first and last name on one line and the address on another, use a formula in the Synopsis field. The Synopsis formula would be FN & " " & LN & CHAR(10) & Address. The CHAR(10) generates a line feed similar to the manual use of CTRL-ENTER. For a record with Peter, Conroy, Maine, the Synopsis field would create:
Peter Conroy
Maine
Post Reply

Return to “PlanMaker 2018 for Windows”