Re: Mail Merge query results with Office 2002

I'm afraid I don't know why Tables are showing up and not Queries, but it appears that you've worked your way around that problem. Thanks for sharing with us how you did that.

-- Vincent Johns <vjohns@xxxxxxxxxxxxxxxxxx>
Please feel free to quote anything I say here.


Jerry M. Gartner wrote:
Here's what I did:

I changed the select queries to a make table queries (user input parameter still pops up where applicable) and then added command buttons to the ui.

Jerry M. Gartner wrote:
Oh, yeah, one vital tidbit: The query contains a user input parameter. Sorry for leaving that out! :)


Jerry M. Gartner wrote:

I'm not having any issues getting the mail merge to work with tables. The queries that are in the database aren't showing up. Only the tables are. I may end up doing a make table query - since only tables are there. I'm not sure why the queries aren't available but they aren't.

[...]

Jerry M. Gartner wrote:

Greetings:

When using Office 2003, from access, after executing a query, I can got to Tools> Office Links> Mail Merge Word Document (SIC) and the query data is available for merging. When doing the same thing with Office 2002 (Office XP ?), this method just opens a word document with the mail merge dialog open. The query data is not available and I don't see adequate filtering abilities to get the information that I want for the mail merge. Please advise as to how one may make query data available for mail merge with Office 2002 (Office XP). Thanks in advance.
.