Documentation/How Tos/Suppressing Blank Address2 Fields in Mail Merge Documents
From Apache OpenOffice Wiki
Here is the situation we are addressing. Sometimes your addresses have two lines for the address part, sometimes they do not.
Bob Jones | Marion Silverman |
101 Main | 888 105th Ave |
Suite 55 | Broomfield, CO 82211 |
Boulder, CO 80022 |
But you have to put in the <Address2> field for everybody, since it is a mail merge. The setup has to be the same.
<Firstname> <Lastname>
<Address1>
<Address2>
<City>, <State>, <Zip>
But with this approach, your addresses look like this.
Bob Jones | Marion Silverman |
101 Main | 888 105th Ave |
Suite 55 | |
Boulder, CO 80022 | Broomfield, CO 82211 |
Ick. How do you suppress that second Address2 line and the corresponding carriage return if there is no content for a particular record, for that Addres2 field?
Select the Address2 field in your mail merge document, choose Insert > Section, and create a conditionally hidden section with this formula.
databasename.tablename.fieldname EQ ""