![]() |
#1
|
|||
|
|||
![]()
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"} |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
Baldeagle | Mail Merge | 8 | 02-11-2013 04:40 AM |
![]() |
Baldeagle | Mail Merge | 13 | 05-29-2012 02:04 PM |
Help with mailmerge??? | foxtrot1981 | Mail Merge | 0 | 12-03-2010 08:21 AM |