MailMerge recipients

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

milco - 21 Aug 2003 15:39 GMT

I am trying to select the following recipients for a
MailMerge. (Using WinXPprof and Word 2002-sp1).

Field A = "R" AND (Field B = non blank OR Field C = non
blank). No matter how I set the ANDs and ORs within the
MailMergeHelper or MailMerge Recipients I don't get the
proper recipients.

Thanks

Reply to this Message

Graham Mayor - 21 Aug 2003 16:20 GMT

You can do this with conditional fields - use CTRL+F9 to enter each pair of
field boundaries.

{IF {Mergefield A} = "R" "{IF {Mergefield B} <> "" "Type your result here"
"{IF {Mergefield C} <> "" "Type your result again here"}" }}

Whatever you want to appear when those conditions you have indicated apply,
enter at the two places indicated. If the conditions don't apply nothing
will appear.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am trying to select the following recipients for a
> MailMerge. (Using WinXPprof and Word 2002-sp1).
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Milco - 21 Aug 2003 18:02 GMT

Thanks for the prompt and helpful reply. I am familiar
with conditional statements and know how to write the
logic. What I am trying to do is not have to write the
statements for each field printed in a directory but do it
theough the MailMergeRecipients wizard. Is there any way
to enter the conditional statement in the wizard?

Thanks.

>-----Original Message-----
>You can do this with conditional fields - use CTRL+F9 to enter each pair of
[quoted text clipped - 18 lines]
>
>.

Reply to this Message