0

I am attempting to get mail merge to process certain conditions eg: if mergefield spouse = 1 and mergefield lawyer = 2 and mergefield children = 3 and mergefield parent = 4 add certain text

or

if mergefield spouse = 1 and mergefield lawyer = 0 and mergefield children = 2 and mergefield parent = 0 add this text

etc So depending on the sequence of the mergefield would depend on the text add

I have tried the following but it doesnt seem to work { IF{=OR({COMPARE { MERGEFIELD "Spouse "}= "0"}, { COMPARE { MERGEFIELD "lawyer"} = "1" { COMPARE {MERGEFIELD "Children "}= "0" }, { COMPARE { MERGEFIELD "Parent"}= "0" })} = "1" "Lawyer Text" ""}

Or { IF{=OR({COMPARE { MERGEFIELD "Spouse "}= "1"}, { COMPARE { MERGEFIELD "lawyer"} = "3" { COMPARE {MERGEFIELD "Children "}= "2" }, { COMPARE { MERGEFIELD "Parent"}= "0" })} = "1" "Family 1 Text" ""}

Or

{ IF{=OR({COMPARE { MERGEFIELD "Spouse "}= "1"}, { COMPARE { MERGEFIELD "lawyer"} = "0" { COMPARE {MERGEFIELD "Children "}= "2" }, { COMPARE { MERGEFIELD "Parent"}= "3" })} = "1" "Family First Text" ""}

1 Answer 1

0

The basic IF syntax, can be nested to test multiple conditions.

Single Condition (basic):

{IF {MERGEFIELD FIELD1} = "CONDITION1" "TRUE" "FALSE"}

Two Conditions:

{IF {MERGEFIELD FIELD1} = "CONDITION1" "{IF {MERGEFIELD FIELD2} = "CONDITION2" "TRUE" "FALSE2"}" "FALSE1"}

Your Example:

{IF {MERGEFIELD SPOUSE} = "1" "{IF {MERGEFIELD LAWYER} = "0" "{IF {MERGEFIELD CHILDREN} = "2" "{IF {MERGEFIELD PARENT} = "0" "add this text" ""}" ""}" ""}" ""}

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .