Export query to word template automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top