Mergefield conditional, need to skip blank line

J

Julie B

Hello,

I am using Mailmerge and have created some conditional formatting in order
to skip certain fields if the data is blank. However, now the blank lines are
being left in my document. Is there another mergefield code I can use to
remove blank lines?

Here is what I have so far:

First three lines are fine, blank lines are skipped because there is no
conditional formatting:
{ MERGEFIELD “First_Name†} { MERGEFIELD “Last_Name†}
{ MERGEFIELD AgencyCompany }
{ MERGEFIELD “Address†}
Then the fourth line is this:
{ IF{ MERGEFIELD “City†} <>â€â€ “{ MERGEFIELD “City†} “ }{ IF{ MERGEFIELD
State } <>â€â€ “{MERGEFIELD State } “ }{ IF{ MERGEFIELD Zip_Code } <>â€â€ “{
MERGEFIELD Zip_Code }†}

I would like to tell the fourth line to skip if it is blank. Any help would
be appreciated. Thank you!
 
M

macropod

Hi Julie,

Assuming you mean that you only want to suppress the line if the City, State and Zip Code are all *blank*, you could code the field
like:
{IF{QUOTE "{MERGEFIELD City}{MERGEFIELD State}{MERGEFIELD Zip_Code}"}= "" "" "¶{IF{MERGEFIELD City}<> "" "{MERGEFIELD City}
"}{IF{MERGEFIELD State}<> "" "{MERGEFIELD State} "}{MERGEFIELD Zip_Code}"}
and attach it to your {MERGEFIELD Address} line. Note the absence of spaces between the fields embedded within the QUOTE field, and
the '¶'. You'd insert a real paragraph mark or line-feed into the code at the '¶' point.

Cheers
 
J

Julie B

Macropod,

Thank you sooooo much! I squealed with delight when it worked, because I
had been trying to figure out something on my own for days.

I just love coming to these discussion boards to find people who know
everything about the programs that I despise. It helps me do my job better!

Thanks again!!!
--
Julie ~ Former WordPERFECT user.
Attempting to soak up all the knowledge from other generous Word & Excel
users to make my job easier.


macropod said:
Hi Julie,

Assuming you mean that you only want to suppress the line if the City, State and Zip Code are all *blank*, you could code the field
like:
{IF{QUOTE "{MERGEFIELD City}{MERGEFIELD State}{MERGEFIELD Zip_Code}"}= "" "" "¶{IF{MERGEFIELD City}<> "" "{MERGEFIELD City}
"}{IF{MERGEFIELD State}<> "" "{MERGEFIELD State} "}{MERGEFIELD Zip_Code}"}
and attach it to your {MERGEFIELD Address} line. Note the absence of spaces between the fields embedded within the QUOTE field, and
the '¶'. You'd insert a real paragraph mark or line-feed into the code at the '¶' point.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top