Outlook VBA to send emails to multiple contact groups with multiple attachments with different subject line for each receipient

jetedf001

New Member
Joined
Jul 7, 2003
Messages
30
A person has left our department and I am having to take over their responsibilities in addition to mine. So, I need a way to cut down and automate a portion of their workload. They send out and receive multiple files to multiple contact groups on a monthly basis.

There are three monthly files that are sent out to close to 50 contract groups on a monthly basis. These files are in the same location (different folders) for the fiscal year and are just saved over each other when they come in. So, we send out a monthly report to providers in April, asking for March data. In this example, data from July through February that the provider has already entered would be included in the file. All of those cells are locked for editing. The provider sends the updated March data into us, we lock the March data and unlock the April data for entry. Then repeat.

The three email attachments go out in a single email separately for each provider. So, during the fiscal year for each provider, I would like to automatically attach the appropriate three attachments relevant to that provider and have a provider specific subject line, something like Provider AAA monthly reports are due May 15. The body of the email can be the same across all emails.

Is this something a macro or VBA could help me with? You guys will be my hero forever, if it can.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,133,615
Messages
5,659,855
Members
418,534
Latest member
Ajith55

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
Top