Automatically save a word document upon closing

[mrchinchin25]

Hello,

I have an Access database, which is opening up a Word Mail Merge document, and automatically merging it with data from the database. This works fine.

Is there any way of coding the Mailmerge document (with all the data in it) to save automatically to a certain location, and to make the filename depend on one of the MergeFields?

Eg, save the document as "VIN-English.doc" where "VIN" is a mergefield.

Thanks,