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 / January 2004

Tip: Looking for answers? Try searching our database.

Mail Merge Wizard Doesn't Display All Queries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Barbara Rain - 09 Jan 2004 15:35 GMT
Using Office XP... mail merge from Access to Word... but the mail merge
wizard only shows one not two queries that exist in my database.

Any idea?

Barbara
Peter Jamieson - 09 Jan 2004 18:56 GMT
By default, Word XP connects to Word using OLEDB and using that connection
method will not display several types of query, including
a. parameter queries (where /Access/ asks you for the values of various
parameters when you execute the query. But OLEDB does not need to run Access
to get its data)
b. queries containing user-defined functions (i.e. written in Access VBA) -
again, Access has to be running to execute these)
c. UNION queries (and probably UPDATE and INSERT queries)
d. queries containing certain predefined VBA functions. I don't know why
some are not "recognised" when most are.

In most cases you can get Word to "see" the query by checking Word
Tools|Options|General|"confiirm conversion at open", going through the
connection process again, and selecting the DDE option when it is offered.
But that starts a copy of Access...

--
Peter Jamieson - Word MVP
Word MVP web site http://www.mvps.org/word

> Using Office XP... mail merge from Access to Word... but the mail merge
> wizard only shows one not two queries that exist in my database.
>
> Any idea?
>
> Barbara
 
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.