Been using Access for a very long time but this is the first time I want to do a mail merge.
I would like everything to work from within Access using VBA Code.
For testing purposes I create a Mail Merge document called 'MailMergeTest.docx' in directory 'C:\My Documents\Word Documents'.
It is linked to 'tblProperty' in my Access database. I can run it manually from Word 2010 but want the output generated automatically from within Access, when the user requests.
How do I accomplish that?