Export query to word template automatically

[Jon L.]

Hello

I'm trying to set up a command that creates a single result query from the selected information on an open form (done). What I'd like to do is automatically export this query, apply it to a mail merge template (that's already created) and have it happen all automatically. I know somewhere I need to define the template file to use. What would the VBA code look like? Basically I'm making labels (not mailing) for products that we create and I've got 3 more situations (3 more forms, queries, templates) to do the same thing to (for different products)

Thanks in advance

-Jon

 

[Albert D. Kallal]

Grab my word merge example. It allows you to pass a query, and it automates
the whole process.

Just take a look at the sample included, and note how the "merge all" button
can use a table, query, or just raw sql.

Check out:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

 

[Meg]

I have a database built with quite a few financial
transactions with quite a bit of detailed info in each
transaction. Each time these transactions occur, there
are 2 or 3 reports which have to be written and people
are spending a lot of time writing these reports and
making sure all the details of the transactions are typed
properly over and over again. Would your word merge code
work to set up the canned reports and merge the
transactions' information from the access tables to make
life easier for everyone?

Thanks for the help.