[Solved] Mail merge prints extra blank pages

Writing a book, Automating Document Production - Discuss your special needs here
Locked
W8SRD
Posts: 1
Joined: Fri Jul 07, 2023 4:09 am

[Solved] Mail merge prints extra blank pages

Post by W8SRD »

OO Write v 4.1.10 using mail merge. Running on Ubuntu 20.04
Printing mail merge of 105 contacts to single document for review, shows no hidden blank pages, looks good. When printing it prints a blank page after every copy of merged document. After a while it calls it quits in the middle of a page and shows it has completed. It has not, many more to go. A closer look at the merge file shows each document, which are one pagers, takes up 2 pages. the second is not visible. I have tried EVERY thing suggested in the previous posts with no change. This is crazy. envelopes will not print because of it either. They just fly all over with varying data like return address on separate envelope from addressee. If I print one envelope manually it is ok.
Last edited by MrProgrammer on Thu Jun 06, 2024 4:31 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
open office 4.1.10 on ubuntu 20.04
User avatar
Zizi64
Volunteer
Posts: 11482
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Mail merge prints extra blank pages

Post by Zizi64 »

Tips:
  • The size of the content to print is larger then the area of the paper. Even if it has only an empty paragraph at the end.
  • Maybe the Writer document has such page style what requires a blank page at end - when you print more than one copies ("Left-Right", "Mirrored" Page style or other)
  • Try the LibreOffice
Last edited by Zizi64 on Fri Jul 07, 2023 7:21 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
thomasjk
Volunteer
Posts: 4454
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Mail merge prints extra blank pages

Post by thomasjk »

W8SRD wrote: Fri Jul 07, 2023 4:25 am OO Write v 4.1.10 using mail merge. Running on Ubuntu 20.04
Printing mail merge of 105 contacts to single document for review, shows no hidden blank pages, looks good. When printing it prints a blank page after every copy of merged document. After a while it calls it quits in the middle of a page and shows it has completed. It has not, many more to go. A closer look at the merge file shows each document, which are one pagers, takes up 2 pages. the second is not visible. I have tried EVERY thing suggested in the previous posts with no change. This is crazy. envelopes will not print because of it either. They just fly all over with varying data like return address on separate envelope from addressee. If I print one envelope manually it is ok.
Go to Tools--->Options--->Openoffice Writer---->Print and uncheck the box under Other that says "Print Automatically Inserted blank pages"
Tom K.
Windows 11 23H2
LibreOffice
NevP
Posts: 10
Joined: Tue Dec 01, 2020 10:30 am
Location: Brisbane Qld Australia

Re: Mail merge prints extra blank pages

Post by NevP »

This isn't marked solved so this may help. The turn off sugg by thomasjk has worked for me in the past but mt LO 7.3 still prints them regardless of the check box.
I find that at printing i can print odd pages only eliminates the blank pages.
I have also exported into PDF and that removes them. This has been usefull in printing multiple pages on one sheet.
Cheers
Libreoffice 7.3 on windows 11
Locked