Saving results of Mail Merge using VBA 1

[bPruFin]

When I run the following code (from Access) ...

doc.MailMerge.Destination = wdSendToNewDocument
doc.MailMerge.Execute

... I get the results of the merged word document in a new file called "Form Letters1".

My question is, how do I refer to this new file so that I can then work with it (e.g. change it's name, save it to a specific folder, etc.)?

 

[PHV]

Have you tried this ?
doc.Application.Documents("Form Letters1")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bPruFin]

Hi PHV,

No I have not. Looks like a good idea and will try it out.

Thanks!

- Bruce