Queries missing from available data sources in mail merge

External Since: Aug 26, 2008 Posts: 1

When I try to do a mail merge using a query in one of my Access databases,
not all queries are showing up on the list when I select the database. This
used to work and showed all the queries in that database, but stopped working.

External Since: Aug 10, 2004 Posts: 2198

Which version of Word/Access?

Typically to see all the queries, including parameter queries, queries that
use user-defined Access VBA functions, and so on, you have to connect to
Access using DDE . he default method since Word 2002 has been OLE DB. To
change to DDE, in Word 2002/2003 check Word Tools->Options->General-Confirm
conversions at open, go through the connection process again, and select the
DDE option when you see it. If you're on Word 2007, the option is in Office
Button->Word options->Advanced (near the bottom) and you may also have to
click the "Show all" button in the Confirm Source dialog box.

Other query types can cause problems too, e.g. if they contain wildcards -
but maybe you could let us know if that is the case.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"faresatpta" <faresatpta.RemoveThis@discussions.microsoft.com> wrote in message
news:74B8E2E1-74BE-4A4C-BC55-E6630C418FAA@microsoft.com...
> When I try to do a mail merge using a query in one of my Access databases,
> not all queries are showing up on the list when I select the database.
> This
> used to work and showed all the queries in that database, but stopped
> working.