If and/or in mailmerge
I am using a template to mailmerge a document using multiple "If" conditions.
The outcome should merge a letter, only if the status is not "Expired" and if definitions shows "Client/Pat" or Client/Set.
Problem is, the info still merges if status is "Expired". What am I doing wrong?
Attached is my template, sample db and my document after merged.
IF Definition1 = Client/Pat OR Definition1 = Client/Set AND Status1 is not = Expired
then letter should merge.
This is the code I am using:
IF{={IF{MERGEFIELD Definition1}= "Client/Pat" 1 0}+{IF{MERGEFIELD Definition1} = "Client/Set" 1 0} \# 0}>0 {IF{MERGEFIELD Status1} = "Expired" "" "Letter goes here"}
|