Thoughts on Mail Merge Automation

J

Jenn68

I am developing a user friendly application utilizing Excel VBA t
create and process a database to be used as the source of data for
Word mail merge.

From Excel, the user may choose to create one of 16 different document
based on the data in the database. The 16 different documents are base
on the recipient lists of the particular merge.

Currently, all I can automate is Excel opening the appropriate mai
merge document. To make the process of finalizing the directory styl
mail merge document hands off for the user, is it possible that upo
opening of the document ...

a) the new document is compiled based on the recipient factor
associated with the mail merge document
b) tagged with a unique file name
c) saved
d) printed
e) word closed and returned to Excel

Thoughts?

Jen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top