VBA for mail merge

cjwatts95

New Member
Joined
Oct 2, 2017
Messages
1
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
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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.
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top