Word Mail Merge 2002 & Access Parameter Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mk2 - 28 Oct 2004 20:55 GMT

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!

Reply to this Message

Peter Jamieson - 29 Oct 2004 09:14 GMT

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

>I have an Access database built with a number of parameter queries that the
> use also uses for various mail merge capabilities.
[quoted text clipped - 14 lines]
>
> Thanks in advance for any help!

Reply to this Message

mk2 - 29 Oct 2004 16:48 GMT

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

> 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
[quoted text clipped - 24 lines]
> >
> > Thanks in advance for any help!

Reply to this Message