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