Apache OpenOffice Community Forum

I have a mail merge template that prints labels. In the template I've chosen a printer and added settings for “manual” feed etc.

If I print the document without doing a merge this works fine, but with the merge the printer setting (in the print dialog) becomes something OpenOffice has made up on its own.

It suggests the standard Windows printer and letter size, a setting we don't use as A4 is the standard over here, so it's not just sending the job to the wrong printer it's using its own settings.

I've even added the same printer setting to the Calc spreadsheet (database), but to no avail.

So, in short, both the mailmerge template and the Calc file is set to the correct printer, but in the print dialog the wrong printer and the wrong settings appear (always the same). If I check the printer settings in the mailmerge document it's correct. It's obvious that the merger process somehow affects the settings.

What have I missed?

Quick work-around:
Merge to file (pdf or odt) and then print that file with your preferred settings.

I can't confirm this issue with LibreOffice 7 with which we print mail merge to labels, envelopes, and small A5 sheets.
https://www.libreoffice.org/discover/li ... penoffice/

Thanks, but I can make all the necessary change manually every time I print. This is a pretty common task though, so it would be much easier if I just could set it up with all the correct parameter once and for all.