Excel Email Sending Made Easy
- Simple Excel add-in (no installation required).
- Inserts an email template sheet directly into your desired workbook.
- Easily send workbooks, Excel sheets, and PDFs.
- Designed to send repeat emails on an ongoing basis.
How Does it Work?
1. Open the add-in OR follow these instructions to install the add-in to Excel.
![excel-send-email-gmail-outlook2 excel send email outlook](https://www.automateexcel.com/excel/wp-content/uploads/2021/06/excel-send-email-gmail-outlook2.png)
2. Simply click the "Insert 'Email Sender'" button.
![excel-email-sender-add-in excel email sender add in](https://www.automateexcel.com/excel/wp-content/uploads/2021/06/excel-email-sender-add-in.png)
An email template is added to your current workbook. You can insert as many email templates as needed. When you save your workbook, the email settings will be saved as well, allowing you to easily repeat the same email.
3. Choose Email Type
Choose between:
- Create email draft in Outlook (recommended for testing)
- Send Email from Outlook
![excel-send-email-gmail-outlook2 excel send email outlook](https://www.automateexcel.com/excel/wp-content/uploads/2021/06/excel-send-email-gmail-outlook2.png)
4. Enter Email Details
Enter your emails details. Use formulas / cell references for dynamic content.
![excel-send-email excel send email](https://www.automateexcel.com/excel/wp-content/uploads/2021/05/excel-send-email.png)
5. Add a Spreadsheet Table to Email Body
![excel-attach-spreadsheet-email excel attach spreadsheet email](https://www.automateexcel.com/excel/wp-content/uploads/2021/05/excel-attach-spreadsheet-email.png)
Select one or more spreadsheet tables to add to the body of the email.
6. Add Attachments
You can easily add a file reference (or references) to send as an attachment when the email is sent.
![excel-attach-workbook-pdf excel attach workbook pdf](https://www.automateexcel.com/excel/wp-content/uploads/2021/05/excel-attach-workbook-pdf.png)
Or you can send the current workbook with several options available:
- Send entire workbook
- Send specific worksheets only
- Save workbook as PDF and send PDF
![excel-attach-files excel attach files](https://www.automateexcel.com/excel/wp-content/uploads/2021/05/excel-attach-files.png)
FAQ and Other Information
Yes, the add-in is 100% free with no usage restrictions.
The add-in is a simple Excel workbook stored as an .xlam file. You can open the .xlam file one time or install the add-in so it's readily available to you. Because the add-in is a simple .xlam file, no installation is required and the add-in should function in any environment that allows macro-enabled workbooks.
The add-in inserts a worksheet into your desired workbook. The worksheet contains all the VBA code necessary to send emails. No coding is required!. However, all the code is visible to you and you can edit it however you'd like.
Once the worksheet is inserted, the add-in is not required to send emails. You can save and share your workbook with whoever you'd like and the email sender worksheet will work.