MailMerge recipients

[milco]

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

 

[Graham Mayor]

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.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Milco]

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.

 

[milco]

My source is another Table in a Word document. No, I am
not proficient in VBA or SQL but I guess I soon will be.
I was just trying to save time and coding by using the
built-in filters but there doesn't seem to be a way to
nest conditional statements.
Thanks.

 

[milco]

Thanks.

-----Original Message-----
No, the simple dialog box that lets you specify a small number of
comparisons is all you get using the standard UI. If you need more control
than that, you either have to use VBA (e.g. to issue the query you want in
an OpenDataSource call), alter the source in some way (e.g. use a
view/query) or specify an SQL query some other way, e.g. using MS Query.

--
Peter Jamieson
MS Word MVP




.