Forms and mail merge

  • Thread starter Thread starter LG
  • Start date Start date
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
 
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)
 
Back
Top