Automate Access 2007 to Word 2007 MailMerge

Question

Presently, my users will open a query, displaying the appropriate records, then from the ribbon choose External Data > Export > More > Merge it With Microsoft Office Word.

I want to automate this process for them, so it can be achieved with a single button click on the Access form.  I can't seem to find the proper macro commands.  Can somebody suggest how to do this using macro or VBA code?

Most of the articles I've been able to find proposed automating Word, filling in bookmarks, etc.  I don't (necessarily) want to go the route of automating Word, unless that is the only way to achieve this.  Having the above clicks automatically performed as a result of the button click would be acceptable.

Thanks...

---

Ron Mittelman

Answer 1

when it comes to MailMerges I always use Albert Kallal' Super Easy Mail Merge technique.  I have used it with different versions of Access, different OS and never experienced any issues.  If you want to take a look, see: http://www.kallal.ca/msaccess/msaccess.html

---

Daniel Pineault, 2010 Microsoft MVP
http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

Hi Ron,

Besides to suggestion from Daniel, you can also refer to sample code in this support article.  Although it's for earlier version Access and Word, the API should work.

http://support.microsoft.com/kb/209976

with regards,

---

Forrest Guo | MSDN Community Support | Feedback to manager