Mergefield conditional, need to skip blank line
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
--
macropod
[MVP - Microsoft Word]
-------------------------
"Julie B" wrote in message ...
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!
--
Julie ~ Former WordPERFECT user.
Attempting to soak up all the knowledge from other generous Word & Excel
users to make my job easier.
|