Word 2010 – Mail Merge multiple conditions

mail-mergemicrosoft-word-2010

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" ""}

Best Answer

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" ""}" ""}" ""}" ""}
Related Question