How to add more filters to a Mail Merge?

[Sam]

In the Mail Merge Helper Query Options Box I can only add
a total of 6 fields to filter on, how do I add more?

 

[Peter Jamieson]

THere is no way using that box. You probably only have two options:
a. create a query or view in the data source or in MS Query (if that is
possible in your case)
b. using Word VBA, use the OpenDataSource statment or the QueryString
property of the MailMerge.DataSource object to issue the necessary SQL. That
should work for data sources such as Access, but I do not know if it will
work with data sources such as a Word table.

 

[Cindy M -WordMVP-]

Hi Sam,

In the Mail Merge Helper Query Options Box I can only add
a total of 6 fields to filter on, how do I add more?

You'd have to edit the QueryString property (VBA) directly.
The tricky thing is, Word can't accept more than 255
characters for the SQL that performs the query...

What's your data source? And what version of Word/Office?

Can you describe the kind of filter/query you're trying to
set up in a bit more detail?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail