General discussion

  • Creator
    Topic
  • #2285328

    MS Word Mail Merge from MS Access VB

    Locked

    by dr_avk ·

    Hello!
    I need to make serial letters with MS Word Mail merge from MS Access Query. This is very easy by using MS Word Mail merge wizard. But I need do that from Access Visual Basic routine.
    I would very grateful, If You could help me!
    Thanks
    Andrey

All Comments

  • Author
    Replies
    • #3312726

      Reply To: MS Word Mail Merge from MS Access VB

      by vinnyd ·

      In reply to MS Word Mail Merge from MS Access VB

      To do a mail merge within Access

      You would use an Access Report (where the letter is created) with data for address etc coming from an access Query.

      Inside the VBA in access you need to run the query to get the data you need for the addresses and then have VBA run the report.

      Trying to have word’s merge wizard open from an Access VBA script is not going to work.

Viewing 0 reply threads