Supress address2 field if blank

users
#1

All,

I have a spreadsheet of Christmas card addresses to print envelopes.
Everything works, except the address2 field - it prints a blank line if
the field is blank. I was looking for a check box to suppress blank
fields, but didn't find one. How do I do this?

Dave,

#2

Try this:
o Ensure that your fields are separated by paragraph breaks, not line breaks.
o Select the relevant field - in this case <address2>.
o Go to Insert | Section... | Section.
o Under Hide, tick Hide and enter for With Condition: address2 EQ "" .
o Click Insert.
o Apply your data to fields in the normal way.

I trust this helps.

Brian Barker

#3

Hi Dave,

I have a spreadsheet of Christmas card addresses to print envelopes.
Everything works, except the address2 field - it prints a blank line if
the field is blank. I was looking for a check box to suppress blank
fields, but didn't find one. How do I do this?

Hidden paragraph dependent on a NULL value of the corresponding DB field ?

This used to somewhere in the built-in help.

https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Print_labels_from_db

Under (d) - instructions are provided on how to hide paragraphs that
contain no db value.

Alex

#4

All,

Thanks for the tips. Some thoughts:
1. All of the workarounds are a mess and in no way are a substitute for
a feature (a simple check box to suppress blank fields) that MS Office
has had since 98. Time to change this developers.
2. A even better link on the subject is:
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Print_envelopes_from_db

Dave,

#5

Taking just a very quick look at this, I agree that there is no *obvious* way in a label to suppress blank lines. If you use the Mail Merge Wizard, though, the option is there.

Not saying this is a solution; I was just looking because I knew I'd seen it in there somewhere. Perhaps someone with the time to do so can do a test with the wizard, look at the result, and see where it shows up in the finished document.

Dave Liesse

#6

I will check on that this weekend when I start batch 2 of the Christmas
cards (yes, I'm a little nuts).

Dave,