How to Skip Empty Lines/Data Fields in Address Labels

Discuss setup / installation issues - Add a spell checker, Language pack?

How to Skip Empty Lines/Data Fields in Address Labels

Postby pcb002 » Mon Jul 27, 2009 10:03 pm

i have worked through the example in the tutorial on this but it doesn't seem to work except for a single example. I have 50 records in my spreadsheet, most of which have one line empty.
(I have the following fields for the addresses: Address 1, address2, address 3, town, county, postcode)

Is there any way in which I can suppress blank fields without going through them all one by one? In Word, it is just a matter of ticking a "Don't print blank fields" tick-box.

Peter
pcb002
 
Posts: 18
Joined: Sat May 24, 2008 1:07 am

Re: How to Skip Empty Lines/Data Fields in Address Labels

Postby TheGurkha » Mon Jul 27, 2009 10:24 pm

This explains it well: Suppressing Blank Address2 Fields in OpenOffice.org Labels, Envelopes, or Other Documents, for Mail Merges.

Also, here's a long page of all kinds of useful stuff to do with labels: Labels Tutorials.
This is another useul source of label information: FSM Mail merge Tutorial.
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: How to Skip Empty Lines/Data Fields in Address Labels

Postby thehobler » Sat Dec 04, 2010 1:06 am

This seems so ridiculous. The suppression of blank fields instructions and responses to this inquiry seem to be dated 2007 - 2009. I can't believe that this otherwise excellent software hasn't been improved to do this easier. I do labels perhaps 3 - 4 times a year and each time it seems to be a major learning curve to get this done. It's almost enough to make me spend the money for MS Office. How in the world can this basic chore be so insanely complicated and not be improved to date. I am determined to find an easier way to get this done. Can anyone suggest another free office suite to try? Don't suggest Lotus Symphony; it's just as bad at this.
Open Office 3.2 on Windows 7
thehobler
 
Posts: 3
Joined: Fri Sep 10, 2010 4:43 pm

Re: How to Skip Empty Lines/Data Fields in Address Labels

Postby Hagar Delest » Sat Dec 04, 2010 12:54 pm

Try LibreOffice. If Google doesn't return anything else, then, either live with it or learn how to code and just do it...
AOO 4.0.1 on Windows 7 and Xubuntu 14.04 (Trusty Tahr)
User avatar
Hagar Delest
Moderator
 
Posts: 25113
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How to Skip Empty Lines/Data Fields in Address Labels

Postby brewgoat » Mon Dec 20, 2010 4:11 am

I had the same question about how to suppress the blank fields. Followed the link above which only took about 2 minutes to do at most and it worked great thanks.
OpenOffice 3.2
brewgoat
 
Posts: 2
Joined: Mon Dec 20, 2010 4:08 am


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 6 guests