Using an access query for mailmerge

[Guest]

Hi,

I have a created a mailmerge document and I would like to populate the data
fields with data from an Access Query.

The problem I have is that when I open the mailmerge in my Word document and
try to select a data source from my access database all I am offered is
tables, no queries.

I think that there must be a setting that needs adjusting somewhere, so that
I am offered queries as well as tables as my data source.

I would be very grateful if anyone has any suggestions on how to solve this
- I'm sure I've seen something similar here before but I can't locate it now.

Many thanks.

Swanse Jack

 

[Guest]

Hi Jack,

Check to make sure that the queries are not action queries (ie. Update,
Append, Delete, or Make Table). Action queries are not available in the Mail
Merge selection--only Select queries are available.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Van T. Dinh]

See The Microsoft Knowledge Base artocle:

http://support.microsoft.com/kb/211193/

for possible solution.

 

[Guest]

I was wondering the same thing and stumbled across it today. If you click on
the options button (I think it's in the "Select Table" window) and click on
the "views" button your queries will appear in the selection list.