FAQ: How to suppress blank merge fields in a mail merge

A common request for mail merges is the need to suppress merge fields when they contain no data.

Example: If you have a label mail merge that is used for creating mailing labels and the Address Line 2 and Address Line 3 merge fields are blank for most but not all of the records, you would want to suppress the merge fields when they contain no data so that there isn't two extra blank lines between the Address Line and the City, State, Zip line.

The following method can be used in Microsoft Word to suppress the merge fields when they contain no data:

1. Toggle the field codes in the mail merge document so that merge fields present in the following manner (Alt+F9 can accomplish this): {MERGEFIELD *Field_name*} 
2. Remove any carriage returns and spaces between the merge field that you want to be suppressed if it is blank and the previous merge field.
3. Insert the following text within the merge field at the closing bracket:
\b "
"

Example:

Original template:

{MERGEFIELD AddressAddress}
{MERGEFIELD AddressAddress2} 
{MERGEFIELD AddressAddress3} 
{MERGEFIELD AddressCity}, {MERGEFIELD AddressState}, {MERGEFIELD AddressZip}

Updated template with blank merge field suppression:
{MERGEFIELD AddressAddress}{MERGEFIELD AddressAddress2 \b "
"}{MERGEFIELD AddressAddress3 \b "
"} 
{MERGEFIELD AddressCity}, {MERGEFIELD AddressState}, {MERGEFIELD AddressZip}
 

See also
DAT   
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.

Schedule Demo

School Name *
Relation to School *
select
Last Name *
Your First Name *
Your Email *
Your Phone # *