MSWord 2010 MailMerge with IF and AND

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

jakali

Thread Starter
Joined
Jul 25, 2016
Messages
2
Trying to mailmerge a document where it would have 1 or 2 signatories depending on the company, and since North Americans doesn't want the signatures dated in this instance, I want to make the field display "Date:" if the signatory field above it is not blank AND Regions is not "North America".

I can get each condition to work on its own but I must be doing something wrong when I combine it.....tried a few variations after doing some research but nothing worked. Here are couple of the options I've attempted:

{ IF {MERGEFIELD REGION} <> "North America" "Date:" "" { IF {MERGEFIELD SIGNATORY 1} <> "" "Date:" "" } }

{ IF {MERGEFIELD REGION} = "North America" "" "Date:" "{ IF {MERGEFIELD SIGNATORY 1} <> "" "Date:" "" }" }

Attached are the test .doc and test data in excel.

Any ideas?

Thanks in advance!
 

Attachments

jakali

Thread Starter
Joined
Jul 25, 2016
Messages
2
Just tried and used this:

{ IF { MERGEFIELD Signatory2 } <> "" { IF { MERGEFIELD Region } <> "North America" "Date" "" } }

The results are a bit weird.......

If it's North America with a signatory then this shows up: {
If it's North America without a signatory then this shows up: IF
If it's Asia Pacific with a signatory then this shows up: {
If it's Asia Pacific without a signatory then this shows up: IF

Also tried:
{ IF { MERGEFIELD Signatory2 } = "" "" { IF { MERGEFIELD Region } <> "North America" "Date" "" } }

The results are more promising as it blanks out when there's no signatory:

If it's North America with a signatory then this shows up: {
If it's North America without a signatory then it's blank
If it's Asia Pacific with a signatory then this shows up: {
If it's Asia Pacific without a signatory then it's blank
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

No members online now.
Top