View Single Post
 
Old 09-30-2015, 05:13 PM
SoonerLater SoonerLater is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Sep 2015
Posts: 3
SoonerLater is on a distinguished road
Default Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)

I am having trouble with an IF... THEN... ELSE situation. I need that if the IF condition is met, that I can insert two mergefields. Or to put it another way, I need the IF found result to insert a concatenated result.

In this example:

Code:
{If {MERGEFIELD "Household_Publish_Address_OK"} = "True" {MERGEFIELD "Household_Address}+", "+{MERGFIELD}"Household_Zip"}}
when the IF condition is TRUE, I only get the contents of {MERGEFIELD "Household_Publish_Address_OK"}. I never get the rest of what I want, which is ", "+{MERGFIELD}"Household_Zip"}.

I've googled and searched for concatenate and concatenation in the Word mail merge environment, but can't find anything relevant.
Reply With Quote