Mail Merge Merge to New Document

[halfbarrel]

Can anyone help me with some code to open a Word mail merge document(Avery 5160 Labels) from Access, then merge this to a New document, then save that document somewhere? This would need to be completly automated since we will be running it in a scheduler. I am then going to email the file to users so they can print out there own labels. I'm good with the email part I just need help automating the mail merge. I have tried a couple of things but after I have the document merged to a new file I don't know how to automate the saving of it. Any help would be greatly appreciated.


Thanks,

Chris

 

[halfbarrel]

Never mind I found some code to do this.
Thanks,


Chris.