Send Emails from Excel - Automatically and by Hand

Add to Favorites
Author: | Edits: don

How to send Emails from Excel using automation and also via a handy button-click.

This tutorial covers everything you need to know to be able to write simple working macros to send emails from within Microsoft Excel and also a simple non-macro method.

You'll learn how to automate:

  • adding multiple recipients
  • sending attachments
  • sending the current workbook
  • changing the email body and subject
  • adding CC (Carbon Copy) recipients
  • adding BCC (Blind Carbon Copy) recipients
  • and more

I also cover a common method that is used to create email macros for Excel, but that is not good practice, explain why it is not good practice, and show you how to change it to make it work better.

Enjoy!


Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Tutorial Details
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course