Hi All,

I have created a macro that converts an excel sale report into a mail merge ready excel template. The excel template is saved into a folder dedicated to this mail merge application along with a copy of the mail merge word template that is prepopulated with the required merge fields from the excel template. The macro that creates the excel mail merge template saves the file into this folder with the same file name every time the macro is run so that when the word template is opened all fields are already selected.

In this testing stage the folder containing the excel and word templates is called 'In Testing'.

The path for the excel template is - H:\Admin\Macros\In Testing\Mail Merge.xlsx

The path for the word template is - H:\Admin\Macros\In Testing\Post-sale shipping request confirmation template.docx

I would like to have the macro that creates the 'Mail Merge' template open up the 'Post-sale shipping request confirmation template' after it has saved the new excel file and perfom the mail merge with a message box confirming that all emails have been sent. The word file should then be closed leaving the excel template open. All I need now is code to perform this (seemingly) simple task!

I hope I have explained this clearly enough. Any help is as always greatly appreciated.

Many thanks,
d_max_c