VBA for mail merge

[cjwatts95]

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

 

[pbornemeier]

What folder contains the separate files?
Are those files all there is in that folder?
Do the files have a set naming format?
What associates a particular file in that folder with a particular email address?
What folder holds the excel mail merge program?
What is the name of the mail merge file?
I assume you want to add the automation code to that program.

With the answers to these (and probably other) questions we may be able to help. Remember we know nothing about your setup, so provide as much detail as possible.