Suppressing blank lines in labels

peter.surrey · Newbie Joined: 22 Nov 2004 Posts: 3 Location: London uk

Using OO 1.1.4 with Linux Slackware 10.1.

If I follow "Printing address labels" in the help file I can print labels from my dbf database. However, when fields are empty blank lines are "printed" on the label.
How can I suppress this and print the labels with no blank lines Please ?

Peter

AndrewZ · Posted: Thu Mar 31, 2005 7:53 am Post subject:

http://documentation.openoffice.org/HOW_TO/word_processing/writer2_EN.html

Scroll down to "How to eliminate the blank address lines?"

8daysaweek.co.uk · Super User Joined: 29 Nov 2003 Posts: 2130 Location: UK

The document aziem refers to has the answer Smile

Here's an answer I received previously:
http://www.oooforum.org/forum/viewtopic.phtml?t=10549

BFN Smile

,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site

peter.surrey · Newbie Joined: 22 Nov 2004 Posts: 3 Location: London uk

Thanks very much for the prompt replies gents.

Peter

JohnV · Posted: Thu Mar 31, 2005 1:13 pm Post subject:

Neither of the above answers deal with Labels which need special handling before you can use the Hidden Paragraph function that they do address. I try to spell this out here:
http://www.oooforum.org/forum/viewtopic.phtml?t=3500

peter.surrey · Newbie Joined: 22 Nov 2004 Posts: 3 Location: London uk

Thank you John - I have a print out for the future

Peter

openofficeorg200812 · General User Joined: 07 Dec 2008 Posts: 5

"How to eliminate the blank address lines?"
"http://documentation.openoffice.org/HOW_TO/word_processing/writer2_EN.html "

The FAQ assumes that each line ends with a paragraph marker. I'm using OO V3 and when I used the OOWriter envelop menu option and inserted database fields, each line was terminated with a return character. The result of the FAQ (as shown below) causes the entire label not to print.

<First_Name> <Last_Name> [i]return[/i]
<Address1> [i]return[/i]
Hidden Paragraph<Addres2> [i]return[/i]
...

I'd rather leave the text as OOWriter created it. I'm still trying to find a solution. This is the first time I've used OO for mail merge. A few hiccups, but it does a nice job.

Thank you.

Bug · OOo Advocate Joined: 29 Oct 2005 Posts: 336

In my opinion, it's better to create a blank label sheet and then insert the Database fields to the document instead of inserting the fields in the label wizard. This eliminates the problem of the wizard's use of line breaks.

JohnV · Posted: Mon Dec 08, 2008 6:21 am Post subject:

If Synchronize is on then it's easy to delete the line breaks and tap Enter to replace them with paragraph breaks. Just do so in the upper left labels and click the Synchronize button.

openofficeorg200812 · General User Joined: 07 Dec 2008 Posts: 5

I started this thread on printing on custom size paper.

http://www.oooforum.org/forum/viewtopic.phtml?t=77964