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.


Question? Ask it in our Excel Forum

Downloadable Files: Excel File