Hello
I am not sure if this is Macro, Word or VBA discussion, forgive me if this is the wrong section.
I have a database for which I need to automate a mail merge.
Want I would ideally like it to do with the press of one button is
1 - Open Word Template
2 - Merge to new Document
3 - Print the new document
4 - Save the word document to a folder with the template name + todays date as the name (or some other way to keep the generated word files unique.)
I am not sure however if I should be looking to code this into the word document or the access database. I tried looking it up in Google, but only found ways to do it manually.
If anyone could point me in the right direction it would be greatly appreciated.
Regards
Dan
I am not sure if this is Macro, Word or VBA discussion, forgive me if this is the wrong section.
I have a database for which I need to automate a mail merge.
Want I would ideally like it to do with the press of one button is
1 - Open Word Template
2 - Merge to new Document
3 - Print the new document
4 - Save the word document to a folder with the template name + todays date as the name (or some other way to keep the generated word files unique.)
I am not sure however if I should be looking to code this into the word document or the access database. I tried looking it up in Google, but only found ways to do it manually.
If anyone could point me in the right direction it would be greatly appreciated.
Regards
Dan
