Forms and mail merge

L

LG

I currently have many forms built that feed into a template letter for mail
merges.
They currently go in and have to go into word to the template and then do a
mail merge from queries in the DB. Is it possible to build a button on the
switchboard and not sure how or what to put a button on that would say merge
and the name of the template. The mail merge would automatically be created
and instead of opening up word and searching for the db on shared drive etc.
Thanks
 
O

o;;

Steve said:
Turn on Macro recorder in Word and manually do your mail merge. This will
generate the code you need for automating the mail merge from Access. Copy
the code then paste it in to the click event of your button. It's not as
simple as all that however. You will need to add to and modify the code to
get it to work in Access.

Steve
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top