Documentation/How Tos/Suppressing Blank Address2 Fields in Mail Merge Documents

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 ""