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
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