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