Automate Access 2007 to Word 2007 MailMerge RRS feed

  • 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.


    Ron Mittelman

    Thursday, June 7, 2012 3:03 PM


All replies