If and/or in mailmerge

Formd · #1 09-28-2021, 05:10 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to insert an image to a word mailmerge document based on the value of a mailmerge field?	Jake93	Mail Merge	3	07-02-2019 05:38 PM
Can you CC somebody on a MailMerge?	constructionjasont	Mail Merge	2	06-28-2017 06:01 AM
Mailmerge to Email with a mailmerge attachment	Baldeagle	Mail Merge	8	02-11-2013 04:40 AM
Mailmerge to Email with a mailmerge attachment	Baldeagle	Mail Merge	13	05-29-2012 02:04 PM
Help with mailmerge???	foxtrot1981	Mail Merge	0	12-03-2010 08:21 AM