Hi All,
I am trying to run a simple mail merge using a quick access toolbar button to open an existing word template with all merge fields set up ready to go and already pointing to an excel data template. This procedure is done after first running another macro that sets up and saves the excel data template. I hope to combine the two macros into one once I can get the mail merge macro to function.
The excel data template is located at: G:\CAT Post Sale Quote Request Mail Merge\Post Sale Ship Request Data Template.xlsx
The word mail merge template is located at: G:\CAT Post Sale Quote Request Mail Merge\Post-sale Ship Request Email Template.docx
I have the following code that I do not fully understand except for the possible error in placement of the excel and word file locations:
I have trawled for days and clicked many links looking for the answer to this. The above code appeared to be the most straight forward approach if only I could adapt it to my file locations.
I'm not sure why I would need to access the excel file as the word template already looks for the data file.....
Can someone please point out where I am going wrong and/or what it is I am missing?
Many thanks,
Bookmarks