![]() |
|
#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"} |
|
|
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 |