Word Mail Merge 2002 & Access Parameter Queries

[mk2]

I have an Access database built with a number of parameter queries that the
use also uses for various mail merge capabilities.

Upon upgrading from Office 2000 to XP(2002), when I try to mail merge, none
of the parameter queries appear.

I recreated all of the queries without parameters and used the selection
criteria in the Word Mail Merge Edit Recipient box. But I have found that to
be unreliable in its results since some of my recipient lists are subject to
multiple parameters.

So, is there a way to get Word XP to allow me to select my original Access
parameter queries as sources for my recipient list?

Thanks in advance for any help!

 

[Peter Jamieson]

You have to revert to the DDE connection method used by default in Word
2000. Check Word Tools|Options|General|"COnfirm conversion at open", go
through the data source selection process again, then choose the DDE option
when it is offered.

The only other way is to use VBA or whatever to get the parameters from the
user, construct the appropriate SQL, and use OpenDataSource or the
..Querystring parameter to issue the query. Not a trivial exercise.

Peter Jamieson

 

[mk2]

Peter:

Thanks for the information. Will the user need to make this DDE selection
every time? Or, once I set it up initially, will it automatically use that
connection method?

Melissa