Ask Your Question

How do I mail merge to postcards (4 per sheet)?

asked 2017-07-07 08:12:23 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have used mail merge before, long ago in M/S Office (circa 1998), but I remember little about it. I am now trying to use it in LibreOffice. I have read the tutorials and gotten things setup for basic letter addresses from a spreadsheet.

BUT, the setup is for one document per page, and I am trying to print postcards (Avery 5689) which is four postcards in landscape mode per page. I have the Avery template loaded and have created the sheet for the message side using that, and have created the return address for the sheet for the address side, but again, LibreOffice mail merge is only allowing one recipient per page. I need four address from the list printed on each sheet or this will not work.

What do I do? TIA.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-07-07 09:13:28 +0200

robleyd gravatar image

See if this helps - from the (AOO) Help:

Designing Labels and Business Cards You can design both labels and business cards through the Labels dialog.

  1. Choose File - New - Labels to open the Labels dialog.

  2. On the Labels tab, under Format, define the label format. OpenOffice Writer contains many formats of commercially available sheets for labels, badges, and business cards. You can also add other, user-defined formats.

  3. On the Labels tab, under Inscription, you can choose what you want written on the labels. This often involves database fields, so that the labels can be printed with varying content, when sending "Form Letters" for example. It is also possible to have the same text printed on every label. Use the Database and Table list boxes to select the database and table from which the data fields are obtained. Click on the arrow button to transfer the selected data field into the inscription area. Press Enter to insert a line break. You can also enter spaces and any other fixed text. On the Format tab you can define your own label formats, not covered by the predefined formats. To do this, select "User" from the Type list box. On the Options tab, you can specify whether all labels or only certain ones are to be created.

  4. On the Options tab page, make sure that the Synchronize contents box is selected. If this is selected, a label only has to be entered (on the top left label) and edited once.

  5. As soon as you click on New Document, you will see a small window with the Synchronize Labels button. Enter the first label. When you click on the Synchronize Labels button, the current individual label is copied to all the other labels on the sheet.

  6. Click on New Document to create a new document with the settings you have entered.

Adapt as necessary to your circumstances.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more

answered 2017-07-07 08:25:18 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Some more information ...

Let's say I need to print 100 postcards initially. The idea is print all of side "a", the message side, using Writer (word) on 25 sheets (4 postcards per sheet). This is a simple straight-forward task using the Avery template in Writer (Word).

Then I can turn the cards over, and print 100 different recipient addresses (along with my return address) on those 25 sheets using Mail Merge within Writer (Word) and Calc (Excel). This is the part I am stumped on, as there doesn't initially seem to be a way to print more than one address per physical sheet of paper (which is four separate cards in my case).

Can you please help? Thanks in advance!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-07 08:12:23 +0200

Seen: 1,092 times

Last updated: Jul 07 '17