Is it possible to include an "OR" in an IF-THEN-ELSE rule for a mail merge letter? I want to do something like this:



IF mergefield A is blank OR mergefield B = "No" THEN "xx" ELSE "yy"

Any help with code for this much appreciated!

You can build quite complex AND & OR tests with field coding.

For AND tests you can use field coding like:
{IF{={IF{MERGEFIELD Field1}= Y 1 0}*{IF{MERGEFIELD Field2}= "" 1 0}}= 1 "True Text" "False Text"}

{IF{={IF{MERGEFIELD Field1}= Y 1 0}*{IF{MERGEFIELD Field2}= "" 1 0}*{IF{MERGEFIELD Field3}= "" 1 0}}= 1 "True Text" "False Text"}
etc.
or:
{IF{={IF«Field1»= Y 1 0}*{IF«Field2»= "" 1 0}}= 1 "True Text" "False Text"}

{IF{={IF«Field1»= Y 1 0}*{IF«Field2»= "" 1 0}*{IF«Field3»= "" 1 0}}= 1 "True Text" "False Text"}
etc.

For OR tests you can use field coding like:
{IF{={IF{MERGEFIELD Field1}= Y 1 0}+{IF{MERGEFIELD Field2}= "" 1 0}}> 0 "True Text" "False Text"}

{IF{={IF{MERGEFIELD Field1}= Y 1 0}+{IF{MERGEFIELD Field2}= "" 1 0}+{IF{MERGEFIELD Field3}= "" 1 0}}> 0 "True Text" "False Text"}
etc.
or:
{IF{={IF«Field1»= Y 1 0}+{IF«Field2»= "" 1 0}}> 0 "True Text" "False Text"}

{IF{={IF«Field1»= Y 1 0}+{IF«Field2»= "" 1 0}+{IF«Field3»= "" 1 0}}> 0 "True Text" "False Text"}
etc.

With the OR tests, changing the final 0 to another number can be used to specify that more than one condition must be met. Setting it to the same as the number of IF tests turns it into an AND test. With care, you can also combine the AND & OR tests.

Note: The field brace pairs (i.e. '{ }') for the above examples 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 practicable to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. The spaces represented in the field construction are all required.

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