Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Use mail merge to send bulk email messages

To be able to send bulk email via mail merge, you must already have installed a MAPI-compatible email program such as Outlook or Gmail. 

The following process assumes that you already have the message you intend to send created and open in Microsoft Word. 

  • Go to Mailings > Start Mail Merge > E-mail Messages.

    Start mail merge with Email messages selected

The mailing list is your data source. For more information, see Data sources you can use for a mail merge.

Tips

  • If you don’t have a mailing list, you will be able to create one during mail merge. 

  • If you are using an Excel spreadsheet as your data source, format the ZIP/postal codes as text to avoid auto-deletion of any leading zeroes. For more information, see Format mail merge numbers, dates, and other values in Excel

  • If you want to use your Outlook contacts as a list source, make sure Outlook is your default email program and is the same version as Word.

Make sure your data source has a column for email addresses and that there is an email address for every intended recipient.

  1. Go to Mailings > Select Recipients.

  2. Choose a data source. For more information, see Data sources you can use for a mail merge.

  3. Choose File > Save.

To learn more about editing, sorting, or filtering your mailing list, see Mail merge: Edit recipients.

  1. Go to Mailings > Greeting Line.

  2. Choose a format. 

  3. Choose OK to insert the merge field.

  4. Choose File > Save .

You can add other fields from your data source to your email message. For more information about this, see Insert mail merge fields.

Note: After inserting fields, you will need to format your email manually. 

To learn how to fix any missing part of your addresses or other fields, see Mail merge: Match Fields.

To change the font, size, or spacing of the merged content, select the merge field name and make the needed changes.

  1. Choose Preview Results, and then choose Next Next record button for mail merge preview results or Previous to see the names and addresses in the body of your letter.

    Screenshot of the Mailings tab in Word, showing the Preview Results group.

  2. Choose Finish & Merge > Send E-mail Messages.

    Screenshot of the Mailings tab in Word, showing the Finish & Merge command and its options.

  3. In the To box, choose the email address column or field from your mailing list.

    Note:  Word sends an individual message to each email address. You cannot CC or BCC other recipients. You cannot add attachments, but you can include links, 

  4. In the Subject line box, type a subject line for the message.

  5. In the Mail format box, choose HTML (the default setting) or choose Plain text to send the document as the body of the email message. 

  6. Under Send records, select one of the following:

    • All records (default).

    • Current record only the record viewable on your screen is sent the message.

    • From and To send only a range of records.

  7. Choose OK to run mail merge.

Go to File > Save. When you save the main document, you also save its connection to the data source. To reuse, open the document and answer Yes when prompted to keep the connection to the data source.

See also

To be able to send bulk email via mail merge, you must already have installed a MAPI-compatible email program such as Outlook or Gmail.  

  1. Go to Mailings > Start Mail Merge > Email Messages.

    mail merge email

  2. In Word, created the email message that you intend to send.

The mailing list is your data source. For more info, see Data sources you can use for a mail merge.

Tips

  • If you don’t have a mailing list, you can create one during mail merge.

  • If you're using an Excel spreadsheet, format the ZIP/postal codes column as text to avoid auto deletion of leading zeroes. For more information about this, see Format mail merge numbers, dates, and other values in Excel.

  • If you want to use your Outlook contacts, make sure Outlook is your default email program and is the same version as Word.

Make sure your data source has a column for email addresses and that there's an email address for each intended recipient. 

  1. Go to Mailings > Select Recipients.

  2. Choose a data source. For more info, see Data sources you can use for a mail merge.

  3. Choose File > Save.

Learn how to edit, sort, or filter your mailing list here: Mail merge: Edit recipients.

  1. Go to Mailings > Insert Merge Field, and then choose the fields to add.

    On the Mailings tab, Insert Merge Field is highlighted

  2. In your document, select Drag fields into this box or type text, and select the text to remove it.

  3. Add and format the fields you want to be included in the email message, then select OK.

  1. Go to Mailings > Preview Results to see how the email messages look.

    On the Mailings tab, Preview Results is highlighted

    To scroll through each email message, use the left and right arrow buttons on the Mailings tab. 

  2. Select Preview Results again to add or remove merge fields.

  3. When ready, go to Mailings > Finish & Merge > Merge to E-Mail.

    Merge to E-Mail is unavailable if you have not selected your default email program.

  4. Choose the To merge field, the subject, and whether to send as text, HTML, or as an attachment. When you send as an attachment, the email has no body text; instead, the message is sent as an attached document. 

  5. Select Mail Merge To Outbox.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Find solutions to common problems or get help from a support agent.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×