Macro to email outlook template based on cell value

uklobster

New Member
Joined
Dec 3, 2003
Messages
30
I have tried to use search, but cannot find anything that does what I want and I don't have any VBA skills !!

To keep it simple I have three columns A,B and C and I am using MS Office 2013 for Excel and Outlook

Column A has the job reference name
Column B has the email address
Column C determines who needs an email, if the cell = "No" then an email needs to be sent to the address in column B and the email subject needs to be "Project: " and the job reference in column A

There is an email template containing the body of the text in this location ""C:\Users\User\Google Drive\Projects\ProjectChase.oft"

Is it possible to write a macro so I can click a button so that excel automatically sends out the email template, with the correct subject line to everyone with a 'No' in column C ?

This would save me so much time as I am manually having to send out loads of emails daily at the moment. Hope someone can help, I would be extremely grateful :D
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

uklobster

New Member
Joined
Dec 3, 2003
Messages
30
Weekend bump, otherwise Monday I have to manually send out loads of emails...

Keeping fingers crossed some good soul helps over the weekend :)

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,122,553
Messages
5,596,806
Members
414,103
Latest member
imamalidadashzada

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