URGENT! Automating Mail Merge via VBA Code

URGENT! Automating Mail Merge via VBA Code

Author

Message

Jason #1 / 2

URGENT! Automating Mail Merge via VBA Code

Hi.

At the moment, to do a mail merge, I have created some querys and use the mail merge wizard which is provided in Access. This database is for a end user and I am trying to protect them from all the queries /tables etc... side of things. Instead of having the user select the query and run the wizard, I would like to know how to automate all of this via VBA code.

This db is being written for Access95. And the document I am merging exists already.

>At the moment, to do a mail merge, I have created some querys and use the >mail merge wizard which is provided in Access. This database is for a end >user and I am trying to protect them from all the queries /tables etc... >side of things. Instead of having the user select the query and run the >wizard, I would like to know how to automate all of this via VBA code.

>This db is being written for Access95. And the document I am merging exists >already.