Forms and mail merge

[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

 

[Arvin Meyer MVP]

I use code like the following on my website:

http://www.datastrat.com/Code/WordMerge.txt

 

[Gina Whipp]

LG,

You might want to have a look at Super Easy Mail Merge about half way done
Albert's page http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[o;;]

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)