Mail merge problems

[gr8R]

I have a macro in Access that runs a query then starts the mail-merge wizard. I hope this means that that it will merge the records found by the query. The problem is when i try to link this query to a word document. When i get to the part of the wizard in word where you select a data source file it doesn't show the query in the database that i want to merge it with. It shows all of the tables and just three of the many queries there are - but not the query i want to merge it with.
If in access i choose to create a new document (instead of linking to an old one) i can get it to show the query that i want to merge with in word but when i select it, it says "Word was unable to open data source" (or something oike that).

I feel like its something really easy or stupid that i am missing here.

Please help.

 

[dynamictiger]

I have found a few alternatives to this approach.

1st you can output the query as an excel file then import it using words built in tools. When I use this I output the file to the temp file and tell my users where it is.

However, the other alternative is a little easier. If wanting to write a letter from access i create a report with an unbound field. I type the standard text as labels and what have you then let the user fill in the blanks.