How to send mass email in outlook from excel

See all How-To Articles

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

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.

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 of these fields need to be formatted as text and not as a number if you want them to appear correctly in the mail merge document.
   (1) Select the numbers that need to be formatted. (2) Then in the Ribbon, select Home > Number, then click the arrow to the right of the number format drop-down list.

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

If you want the decimal point to show in the mail merge, you have to physically type them into each cell.

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

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 then select Mailings > Start Mail Merge > E-mail Messages.

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

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

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

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

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

Send Emails

To create the emails, in the Ribbon, select Mailings > Finish > Finish & Merge and then select Send Email Messages.

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.

1. The Google Workspace Marketplace will open. (1) Type “Mail Merge” into the search box, and then press Return on the keyboard. (2) Scroll down until you find Mail Merge for Gmail (Gmail Merge) and then click on that add-on.

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

1. Click Install to install the add-on.

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.

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

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

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) EDIT to edit the 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.

1. To send the emails. click on the SEND EMAILS button. The number shown in the bottom left corner depends on the rows in your data list.

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