Stan Grigiski wrote:
I noticed that when I try to mail merge a data base for labels, the program
will not supress a field if there is no entry; it will create a space on
the lable. For example, if I have the field "address 1" set for street
number and street name and the field "address 2" set for apt#, if a person
does not have an apt #, it will put a space between the address and city,
state and zip code. The link below seems to be the only fix I can find.
I haven't used mail merge to produce labels, but have used it for
envelopes and other one-page-per-recipient type documents. I'm pretty
sure when I've needed to suppress empty lines I've used hidden
paragraphs rather than sections. Insert > Fields > More Fields >
Functions > Hidden Paragraph, and enter a condition (similar to what
that tutorial used for sections). If View > Hidden Paragraphs is
enabled, they'll still show on screen but not in print preview (or
Needing to change the line breaks ("soft returns" in your link) to
paragraph breaks ("hard returns") seems to be specific to labels rather
than mail merge fields. I'm not sure why they're done that way.
Is there any way this issue can be addressed on the next update?
A few thoughts:
- There may be times when you want lines for blank fields left in, so it
would need to be an option when creating the labels. Software can't
(yet) read your mind ;o)
- Perhaps the wizard for labels should insert paragraph rather than line
breaks between each field. At least then setting conditional paragraphs
wouldn't involve first changing all the line breaks.
- As Mark Phillips pointed out, there is a tick box on the mail merge
wizard (Tools > Mail Merge) when adding a standard address block to
"suppress lines with just empty fields". Adding a similar option to the
labels wizard may be a valid request. Possibly already filed at
<https://bugs.documentfoundation.org/show_bug.cgi?id=35798> although the
description appears to be confused between labels and mail merge.
Feature requests can be filed at <https://bugs.documentfoundation.org/>.
Don't forget to do a quick search first in case someone else has already
filed the same request. Select "Enhancement" for severity. It would be
handy to post the bug numbers you find or file here so others reading
this thread can find them easily. If you're not sure what to select for
any of the other fields feel free to ask here.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy