How to Send Mass Email From List in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on March 28, 2023

This tutorial demonstrates how to send a mass email from a list in Excel and Google Sheets.


BulkEmail list to merge


Collaborating between Excel and Word allows you to send bulk emails from a list in Excel automatically by using the Word mailing feature.

Create Mailing List

  1. Set up mailing fields in Excel by creating a list of names, email addresses, and customized body messages in Excel.
  2. The top row in the worksheet must contain the field names for the mailing list.


BulkEmail Mailing Fields


  1. Format any values as text fields so they can merge correctly in Word.
    The example above, has an order value, a percentage discount, and a final total. All fields need to be formatted as text and not as a number if you want them to appear correctly in the mail merge document.
    Select the numbers that need to be formatted. Then in the Ribbon, go to Home > Number and click the arrow to the right of the number format drop-down list.


BulkEmail number format


  1. Select Text from the drop-down list to format the numbers for text.


BulkEmail text format


If you want the decimal point to show in the mail merge, physically type them into each cell (or use a formula to insert decimals as text). The green triangles in these images are due to values being stored as text, but that’s intentional here. Ignore the warning messages or remove them globally.


BulkEmail decimals


If you want percentages to show up properly, make sure to type in the actual percentage value (i.e., 10 instead of 0.1).


BulkEmail format percent


  1. Once you have filled in the list and formatted the data correctly, save and close the file.

Mail Merge in Word

  1. In a blank Word document, click in the Ribbon and go to Mailings > Start Mail Merge > E-mail Messages


BulkEmail word ribbon


  1. Start typing the email, and then in the Ribbon, go to Mailings > Write & Insert Field > Insert Merge Field. Select the appropriate field from the list.


BulkEmail Insert field


  1. Continue to create the email, inserting the fields where required.


BulkEmail create email


If you want $ or % signs to show up in the mail merge, make sure to put them before or after applicable fields.


BulkEmail dollar percent


  1. To see a preview of your email, in the Ribbon, go to Mailings > Preview Results > Preview Results.


BulkEmail preview


  1. To view another record, or scroll through all the records, you can click on the relevant navigation button in the Preview Results group.


BulkEmail navigation


Send Emails

To create the emails, in the Ribbon, go to Mailings > Finish > Finish & Merge > Send Email Messages…


BulkEmail send


Send Mass Email in Google Sheets

With default settings, Google Sheets doesn’t work directly with mail merge in Word, but you can still send mass emails in a similar way.

  1. First install an add-on. Open a Google sheet. In the Menu, select Extensions > Add-ons > Get add-ons.


BulkEmail gmail extensions


  1. This opens the Google Workspace Marketplace.
    Type “Mail Merge” into the search box, and then press ENTER on the keyboard.
    Scroll down until you find Mail Merge for Gmail (Gmail Merge). Click on that add-on.


BulkEmail gmail addin


There are many mail merge add-ons available; this tutorial concentrates on the one selected here.

  1. Click Install to install the add-on.


BulkEmail gmail install addin


  1. Then, log into your Google account and give permission for the add-on to access your Gmail. Once you have done this, the add-on is installed. Click DONE.


BulkEmail gmail addin done


  1. Create or open the list that contains the data you wish to email in your spreadsheet.


BulkEmail gmail email list


  1. In the Menu, select Extensions > Mail Merge for Gmail > Start.


BulkEmail gmail mailmerge addin


  1. A standard Gmail template shows up with the first name shown as the recipient.
    Note that (1) the column with your recipients’ email addresses is automatically selected, but you may need to change that. Click (2) the pencil icon to edit the template.


BulkEmail gmail template


  1. Adjust the template as necessary. You can amend the template name and the email subject. When you add in fields from your spreadsheet, the fields need to be place in double curly brackets ({{field}}) as shown below. You can also adjust the format of the text using the format Toolbar provided (font color and size, bold, italic, underline, alignment, etc.).
  2. Click SAVE AND CLOSE to save the template.


BulkEmail gmail edit template


  1. Click the SEND EMAILS button. The number shown in the bottom-left corner (here, 9) depends on the number of rows in your list.


BulkEmail gmail send emails


  1. A message shows up indicating that the emails are being sent, and another will appear once the emails have been successfully sent. Click CLOSE to dismiss the message.

BulkEmail gmail sent msg


See also

AI Formula Generator

Try for Free

See all How-To Articles