How to access an existing Word doc from a button on a Form to do a mail merge.
How to access an existing Word doc from a button on a Form to do a mail merge.
This is a fairly common topic and many tutorials on web. Here is one https://rtmccormick.com/2015/11/23/a...ba-and-access/
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
How to create a letter in Word that will populate data from a form in Access. This letter will be constantly used over and over. The data used in the letter will be an email, date, time and number of persons from the data base form. I also want this letter to pop up with a button on the form. How do I do this?
I have never had to do mail merge. Doesn't the referenced link provide example code?
Why do you need to use Word at all? Will an Access report not provide the same result?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Albert Kallals' super easy word merge may be a good starting point. http://www.kallal.ca/msaccess/msaccess.html
it may not be what you want but picking through the code may help.
I agree with june7 however that it seems an unnecessary step.
I have used mail merge for various purposes over the years.
This was normally where the required output / layout was too complex for Access reports.
In such cases, I also found Albert Kallal's super easy mail merge very useful.
The code is complex but it's implementation is easy.
It is also customisable if you need to modify it...but I doubt you will need to do so.