Discussion Locked

MS Word Mail Merge from MS Access VB

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by vinnyd

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.

This discussion is closed to new replies.