Email from Excel

Rapid emails from Excel

Dealing with lots of emails?  Get this free rapid email tool to save you time. 

Quickly create email templates in Excel to send them to groups of people.  It is so simple to use.  This tool was quickly developed using Easy Ribbon Builder.  You can build even more powerful and more customised tools with Easy Ribbon Builder.

 

Bulk email from Excel

How to create emails in Excel?

 

Step 1. Download and open this template

Step 2. Add attachments (if required)

  •  Click Email tab > add attachment
Email from spreadsheet
  • Select file to add as an attachment then click open.
Email from Excel

Note: If you need to delete an attachment, simply delete its corresponding filename and path text in the [email attachment table].

Step 3. Complete template email table

  • Fill out [To, BCC, CC, Email Subject, Email Body] columns.  How you fill these out depends on how you intend to send the emails, therefore it is recommended to read step 4 before completing this step.

Excel to Outlook

Step 4. Create Email

You have the following 4 options to create emails

Excel to Email

  1. Creates a draft group email and displays this for you to edit or send. Please see group email notes below to understand how this email is configured.
  2. Creates and immediately send a group email. Please see group email notes below to understand how this email is configured.
  3. Creates draft emails for every row with a [To] email address in the [Email Template Table]. Each email drafted is displayed on your screen so may not be desirable to draft too many individual emails.  Please see individual email notes below to understand how these emails are configured.
  4. Creates and sends emails for every row with a [To] email address in the [Email Template Table]. Please see individual email notes below to understand how these emails are configured.

What are group emails?

  • Group email option creates a single email to all [To, CC, BCC].
  • Only uses the top row [Email Subject] and [Email Body] of the email template table only.
  • Email includes all attachments in the [Email attachment table]

Example of draft group email

Send emails from Excel

What are individual emails?

  • Individual email option creates separate emails for every single row that contains a [To] email address. Email details are taken from each row.
  • Each email includes all attachments in the [Email attachment table]

Example of draft individual emails

 Rapid bulk emails from Excel