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

Attached Files

	Template.doc (42.0 KB, 8 views)
	Data.xlsx (8.9 KB, 7 views)
	Merge Outcome.doc (27.0 KB, 6 views)

You need a space after the >

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you for responding Paul.
I placed a space after the > and tested, but got the same results.

IF{={IF{MERGEFIELD Definition1}= "Client/Pat" 1 0}+{IF{MERGEFIELD Definition1} = "Client/Set" 1 0} \# 0}> 0 {IF{MERGEFIELD Status1} = "Expired" "" "Letter goes here"}

Are you actually completing the merge, or just previewing it?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul
I actually ran the merge. Did it a few times.

Are you using the correct capitalizations for the tests? Also, what are the possible outputs for Definition1?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul
After reviewing my codes several times, I removed an extra space in one of my
mergefields. Because the mergefield was incorrect it did not work. After correcting the mergefield, it works. Thanks as always for your help.