Printing Labels

Discuss the database features
Post Reply
MDEFORTUNA
Posts: 2
Joined: Thu Aug 10, 2017 3:54 pm

Printing Labels

Post by MDEFORTUNA »

I have a mail merge application using Base to print labels. Works great except when I print. It prints 1 page of labels and 1 blank page. Any suggestions on how to resolve this issue?
OpenOffice 4.1.3 on Windows 10
User avatar
MTP
Volunteer
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: Printing Labels

Post by MTP »

Are you mail merging into a Writer file? How many pages of labels are there?
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
MDEFORTUNA
Posts: 2
Joined: Thu Aug 10, 2017 3:54 pm

Re: Printing Labels

Post by MDEFORTUNA »

Yes, into a Writer file. 300+ pages.
OpenOffice 4.1.3 on Windows 10
User avatar
MTP
Volunteer
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: Printing Labels

Post by MTP »

And everything looks correct in the Writer file? Have you tried a different printer, or a pdf printer?
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Printing Labels

Post by John_Ha »

Is the Page format set to LEFT or RIGHT so that a blank page is being added?

Do you have a paragraph return or manual new page which is causing a new, empty page to be printed? View > Non printing character's to see what is happening.

Do your labels extend beyond the bottom page margin? Page size? causing the spill?

Do you have a page format (eg Letter) which is larger than the paper in the printer (eg A4). Do some experiments to be certain you have a small gap at the bottom of your page between your last label and the margin.

What happens when you look at it in Page Preview?
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Arineckaig
Volunteer
Posts: 828
Joined: Fri Nov 30, 2007 10:58 am
Location: Scotland

Re: Printing Labels

Post by Arineckaig »

MDEFORTUNA:
Works great except when I print. It prints 1 page of labels and 1 blank page. Any suggestions on how to resolve this issue?
Try this suggestion when extra page is printed from Mail Merge.
When this issue has been resolved, it would help other users of the forum if you add the word - [Solved] - to the Subject line of your 1st post (edit button top right).
AOOo 4.1.5 & LO 6 on MS Windows 10 MySQL and HSQLDB
Post Reply