Excel VBA Macro: Send Email with Outlook (Step-by-Step Tutorial)

Excel VBA Macro: Send Email with Outlook (Step-by-Step Tutorial). In this video, we create a macro that automatically sends an email with Outlook. We use HTML to compose the body of the email and go over how to change the font size and font type. We also go over how to use the current date in the email subject line, and how to change the format of the date.

#ExcelVBA #ExcelMacro

[chazzhoskins]

This video changed my life at work six months ago. Thank you!

[titapao]

Hi Greg,

Thanks for this tutorial. Can you please share also how to set data classification on email thru vba? TIA

[HarryDocker]

Hi, I was wondering if there's anyway to get it to send an email if a column contains a name for example. My logic is D2:D300 could contain multiple names but I want the code to say if it says Harry email send an email to A address linked to that name but also send it to Paul if D2:D300 also contained Pauls name at some point I just can't work it out

[brenthlennardbalisi]

Hello Greg,

Thanks for this tutorial. Can you provide me a code with a msg box asking if the automated email is to be encrypted or not? I tried different codes online, there's no error but it isn't applying the encryption/

[hansiman]

would be nice when sb shows the adjustment of the fu.... color

[deepakbhanushali]

I have used data validation in A Column where it check for duplicate Name as well as Text Length which should not be > 30 formula is =AND(LEN(A2)<=30, ISTEXT(A2)), OR(COUNTIF($A$2:A7, A2))=1 but nothing happens it tried to change the formula as =AND(LEN(A2)<=30, ISTEXT(A2), OR(COUNTIF($A$2:A7, A2))=1) but still does not work can you guide me we this formula

[eduardosavinon]

how do you add a hyperlink in vba in Outlook

[deepakbhanushali]

How to change font of body in vba if I am sending multi email with cell value (different party Name) in each name