Mail merge using a query with parameters

[jrh]

I just upgraded to Office 2003 Professional and I can't
create a mail merge document using a query with
parameters. When I go to the "Select Data Source" part
of the mail merge helper the queries with parameters
don't show up as a choice. I tried deleting the
parameters, then selecting the query, save the document,
and then add the parameter to the query, but the I get an
error message "This operation cannot be completed because
of dialog or database engine failures. Please try again".
I created documents with Office 2000 using queries with
parameters and it worked OK.
Any ideas?

 

[Cindy M -WordMVP-]

Hi Jrh,

I just upgraded to Office 2003 Professional and I can't
create a mail merge document using a query with
parameters. When I go to the "Select Data Source" part
of the mail merge helper the queries with parameters
don't show up as a choice

Parameter queries require a DDE connection, since this
works directly with the Access interface. Word 2002 and
2003 use a new method, OLE DB, by default. See the Word
2002 section of my website on how to choose connection
methods.

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

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