PDA

View Full Version : How to provide a filename for automated mail merge



DaveBF
10-18-2011, 12:59 PM
I'm automating a mail merge during Document_Open.
That works fine.

I want to provide a filename that will be used when the users saves the document or does "save as...".

I see a lot of examples on how to do the Save As and provide a filename but I don't see how to set the filename of the new document without automating the save.
Here's some of my code:

'Do mailmerge
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With

How do I provide the filename for the new document?
Thanks.