How to Email a Mail Merge | Send Bulk Emails from Word

Use Word’s Mailings feature to personalize content from an Excel list, then finish in Outlook Classic to send each message individually.

Sending fifty personalized emails by hand takes an afternoon. The fastest route is to learn how to email a mail merge using Word’s Mailings feature and Outlook Classic — you write one template, pull names and addresses from an Excel spreadsheet, and let the software handle the rest. No third-party service, no monthly fee, just the tools already on your Windows PC.

What You Need to Get Started

The mail merge process requires four things: a data source, a Word document, Outlook Classic, and a Windows PC. Mac users cannot use this exact method — skip to the Gmail alternative covered below.

• Excel file — a .xlsx or .csv with column headers like FirstName, LastName, and Email. One row per recipient.
• Word — version 2016, 2019, 2021, or Microsoft 365. All use the same Mailings menu path.
• Outlook Classic — must be installed, set as the default email program, and logged into the same Microsoft 365 account as Word. The new Outlook does not work.
• Windows 10 or 11 — 64-bit required. The “Send E-Mail Messages” option does not exist on Mac.

Email a Mail Merge in Word: The 12-Step Sequence

Microsoft documents a twelve-step sequence for sending bulk email from Word. Follow the steps in order — skipping one usually breaks the merge.

1. Prepare the recipient list — Open Excel and create column headers: FirstName, LastName, Email. Add at least one test row with real data. Save as .xlsx or .csv.
2. Open a blank Word document — Go to Mailings > Start Mail Merge > E-mail Messages.
3. Connect the Excel list — Click Mailings > Select Recipients > Use an Existing List. Browse to your Excel file and select the correct sheet if prompted.
4. Save the Word file — Hit File > Save before doing anything else. An unsaved document can lose the connection during the merge.
5. Insert merge fields — Place your cursor where you want personalization (the greeting line or the message body). Click Mailings > Insert Merge Field and choose FirstName, LastName, and any other columns you added.
6. Add a greeting line — Click Mailings > Greeting Line for a formatted salutation like “Dear John.”
7. Preview the results — Click Mailings > Preview Results. Use the arrow buttons to scroll through records. Check that each recipient’s name appears correctly.
8. Adjust formatting — If the merge fields look raw (like <<FirstName>>), you are still in the editing view. Preview Results shows the final personalized version.
9. Go to Finish & Merge — Click Mailings > Finish & Merge > Send E-Mail Messages. This hands off to Outlook.
10. Set the email column — In the dialog, set To to your email column header (e.g., Email).
11. Write the subject line and choose format — Type your subject line. Set Mail format to HTML (recommended) — Plain Text strips all formatting, fonts, and images.
12. Send it — Choose All for the record range. Click OK. Outlook sends each message individually. They appear in your Sent Items folder.

For the official reference, Microsoft’s mail merge documentation covers every option in detail.

Mail Merge Requirements at a Glance

The table below covers the key compatibility points for the Word + Outlook method.

Common Mistakes That Break Your Mail Merge

Most mail merge failures come from one of these five errors. Each is easy to fix once you know what to check.

• Missing email column — The Excel list must have a column specifically for email addresses. If the header says anything other than “Email” or an equivalent, the merge cannot find it. Rename the column to Email.
• Using New Outlook — Microsoft’s new Outlook app does not support the mail merge handoff from Word. Switch back to Outlook Classic under Settings > General in Outlook.
• Selecting Plain Text — Plain Text removes all fonts, colors, images, and layout. Stick with HTML unless every recipient needs plain text only.
• Working from an unsaved file — Word needs a saved document to maintain the connection to the Excel data. Save before starting the merge.
• Skipping the test row — A single test row with real data lets you preview and catch formatting issues before sending to hundreds of people.

Can You Add Attachments, CC, or BCC?

No — Word’s native mail merge cannot add attachments, CC, or BCC recipients. If you need those, you have two options. The first is a third-party add-in like Merge Tools, which adds a “Merge with Attachments” option to the Mailings tab. The second is switching to the Gmail + Google Sheets method below, which supports all three through Google Apps Script customization.

What If You Use a Mac?

Word on Mac does not include the “Send E-Mail Messages” option. There is no direct equivalent. The simplest workaround is to use Google Sheets and Gmail with Google Apps Script. Google provides a mail merge template that sends personalized emails through Gmail with attachments, CC, and BCC support. The setup takes about 20 minutes and works entirely in a browser.

Mail Merge at a Glance: Word vs. Google Sheets

If the Windows + Outlook method feels restrictive, the Google alternative covers more ground for cross-platform users.

The Final Checklist for a Successful Mail Merge

Run through these checks before clicking Send to avoid the most common failures.

• Excel file saved with Email column header and at least one test row.
• Word document saved on disk before the merge starts.
• Outlook Classic is set as the default email program and logged in.
• Mail format set to HTML unless plain text is intentional.
• Preview Results checked for all records — no stray merge field codes visible.
• If attachments or CC are needed, the mail merge will not work natively — use a third-party add-in or the Google Sheets alternative.