Mail merge automation

giovanniroi · Post by **giovanniroi** » Fri Dec 02, 2011 3:49 pm

Dear Support,
I have a Word 2003 documents that include data from a Access 2007 table and I need to automatize the mail merge activity.

The action that I need to automatize are:

1) Open the Word Document
2) Confirm the request from Word to execute the data selection
3) execute the mail merge
4) Select the printer to use for the printer execution
5) Insert o confirm the name of the document make from the mail merge.

Can You help me?

Thank's for the support.

Giovanni Roi

Post by **Marcus Tettmar** » Fri Dec 16, 2011 3:09 pm

You should be able to record that inside Word and create VBA code. Do you want Macro Scheduler to do some part of it?

giovanniroi · Post by **giovanniroi** » Fri Dec 16, 2011 3:26 pm

I tried to record the phases of the mail merge but the registered commands can not be used to create a macro.

Thank's

Giovanni Roi

Post by **Marcus Tettmar** » Fri Dec 16, 2011 3:28 pm

So you could automate those steps with Macro Scheduler. Which part do you have a problem with? We might need to see screenshots to be able to help.

giovanniroi · Post by **giovanniroi** » Fri Dec 16, 2011 5:09 pm

I have problem to:

2) Confirm the request from Word to execute the data selection : This is done by pressing a button that is activated from Word when I open the Word file.
3) execute the mail merge: thie is apply with a command selection in the Word Menu ( File, Letter.etc.)

after this activity I need to:
4) Select the printer to use for the printer execution
and
5) Insert o confirm the name of the document make from the mail merge.

This are the critical Step.

Thank's for the Support

Giovanni Roi

Post by **Marcus Tettmar** » Fri Dec 16, 2011 5:41 pm

You should be able to do this by sending the appropriate keystrokes. If you want more specific help we'd need to see screenshots.