Automated Emails from a Macro Button?

[00pumpkin]

Hello All,

I am trying to automate a huge part of my morning by creating a macro that will send out individual emails to people listed within a report that I export into excel daily. On any given day there can be anywhere between 10 to 30 rows so its a lot of emails that need to go out.

There will need to be one email per row that goes out to the emails listed in columns D:G. Column G will always have the same email while the emails in column D:F may be different depending on the file. In addition, column H has a formula that pulls information based on columns B:C. So, the only static fields that will always be the same regardless of the row are G and I.

I have attached an excel file below to give you an idea of what I'm trying to accomplish with a snapshot of the email as well.

Email Template.xlsx

Any help will be greatly appreciated.

Thank you!

[Aks2014]

You don't need to write a macro to achieve this. Look for "Mail Merge" and you will find in-built MS Office functionality that will do exactly what you need.

[00pumpkin]

Wont that just send one message multiple people? What I need is one standard message sent out to varying emails depending on the row in excel as well as varying subject lines.

[Aks2014]

Just looked at your attachment. I'm pretty sure MailMerge is what you're looking for.
I've used it exactly as you are trying to do - with recipients, etc. listed in rows of an Excel sheet.

[00pumpkin]

I tried and the Mail Merge will only send a "message" to one email address.

For what I am trying to do, one message needs to go out to 3 different email addresses within a given row and CC a constant email address. I don't want to send out single messages to each because if they reply everyone needs to be on the email.

Does anyone know how to create a Macro to do this?

[00pumpkin]

Anyone else have any ideas on how to build the macro?