Hi all,
I have an excel set up for with data gained through site testing (this includes a mail merge worksheet, putting data into mail merge friendly format) and these will all be saved as seperate files, and i also have a mail merge that is set up to put this into a report that can be sent to the customer
I am able to open the mail merge and manual select the individual workbook and worksheet with the site test data in it and the mail merge can run success,
I would like to automate this but cannot figure out how to even start with this
Thanks for any help you can give me
I have an excel set up for with data gained through site testing (this includes a mail merge worksheet, putting data into mail merge friendly format) and these will all be saved as seperate files, and i also have a mail merge that is set up to put this into a report that can be sent to the customer
I am able to open the mail merge and manual select the individual workbook and worksheet with the site test data in it and the mail merge can run success,
I would like to automate this but cannot figure out how to even start with this
Thanks for any help you can give me