Mail Merge and VBA code to save the file

[jray9242]

Is there a way to do a "Mail Merge" and once it has complete it, save the Word doc to a file?

Here is what I have.

Word 2007 file called, "Event.doc"
Excel 2007 file called, "Company"

Word 2007 fields to merge: Last Name, First Name, Company
Excel 2007 fields to pull from: Same

I know how to do a mail merge, but what I need is the save each one like this.

Save As: "Company" "Last Name".doc

Thanks for the help.

[macropod]

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

[jray9242]

Sweet! That will work.

Thank you,

Jim