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

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.