Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2003

Tip: Looking for answers? Try searching our database.

Mail merge using a query with parameters

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jrh - 04 Dec 2003 20:06 GMT
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- - 05 Dec 2003 17:06 GMT
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
Signature

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

:-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.