automatic mail-merge to saved document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis - 16 Nov 2006 22:20 GMT

I already have a Word document that does mail-merge from a .txt file, this
works fine. What I'd like to do is automate the process so that the user
doesn't have to click the "merge to new document" button. I'd also like to
automate the Save process so that as soon as the document is merged, the new
document is saved as a Word document. Ideally, I'd like to control the name
of the new document each time by assigning it a date/time stamp name, or
something similar. The main objective is to automate the process so that
when the merge document opens, it automatically performs the merge, then
automatically saves the resulting document to a new (unique) name, then
automatically closes the original document. Simple? Macro?

For example; I have a mail merge document named notice1.doc that has a data
source (.txt file) defined and all of the associated mail merge info ste up.
What I would like to happen is when the user opens notice1.doc, it opens
Word, opens notice1.doc, performs the mail merge, saves the new document as
yyyymmdd-hhmmss.doc, then closes completely.

Thanks for anyone that can help.

Reply to this Message

Doug Robbins - Word MVP - 17 Nov 2006 04:18 GMT

See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I already have a Word document that does mail-merge from a .txt file, this
> works fine. What I'd like to do is automate the process so that the user
[quoted text clipped - 20 lines]
>
> Thanks for anyone that can help.

Reply to this Message

Dennis - 17 Nov 2006 15:59 GMT

Thanks Doug. I will look at the linked site and see if it helps.
Dennis

> See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
> at:
[quoted text clipped - 30 lines]
> >
> > Thanks for anyone that can help.

Reply to this Message