if true AND nested or?

[jriker1]

Trying to do a mail merge and can't figure this one out. Basically is:



If card = "Yes" AND (Donate = "Yes" or Amount <> "" or merit = "Yes") print "whatever I'm going to print".

So card needs to be yes for starters, and then if any of the conditions in the brackets are true then print otherwise do nothing. How would I do this?

Thanks.

JR

[macropod]

You could use a field coded as:
{IF{={IF{MERGEFIELD Card}= "Yes" 1 0}*(({IF{MERGEFIELD Donate}= "Yes" 1 0}+{IF{MERGEFIELD Merit}= "Yes" 1 0}+{IF{MERGEFIELD Amount \# 0}= 0 0 1})>0)}= 1 "True Text" "False Text"}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. The spaces represented in the field constructions are all required.

There is a macro for turning the above into a working field code in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html

[macropod]

Cross-posted at: https://answers.microsoft.com/en-us/...5-c6f8276485dc
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

[jriker1]

Thanks macropod. I'll give it a try. Noticed there is an extra end/right squiggly bracket vs the start/left brackets. Have to figure where that is.

Thanks.

JR

[macropod]

Originally Posted by jriker1

Noticed there is an extra end/right squiggly bracket vs the start/left brackets.

No, there isn't - they're exactly balanced.

[jriker1]

Also I'm using ctrl-F9 for all the {} however this passes and this gives an Unknown op code when testing:

Pass:
{IF{IF{MERGEFIELD Card}="Yes" 1 0} = 1 "HI"}

OP Error:
{IF{IF{MERGEFIELD Card}="Yes" 1 0}+{IF{MERGEFIELD Card}="Yes" 1 0} = 1 "HI"}

JR