Mail merge is one of those features that sounds intimidating until you actually use it, and then you wonder how you ever lived without it. Whether you need to send personalized newsletters to 500 subscribers, invoice reminders to clients, or customized offer letters to job applicants, mail merge lets you do it all without typing a single name twice. In this guide, I'll walk you through exactly how to send emails through mail merge using Microsoft Word and Outlook, from setting up your data source all the way to hitting that final send button.

What Is Mail Merge, And Why Should You Care?

At its core, mail merge is a process that combines a template document with a list of data to produce multiple personalized copies. In the context of email, you write one message, connect it to a spreadsheet or contact list, and Word + Outlook work together to send each recipient their own individually addressed version.

Think of it like a mail factory. Your template is the assembly line blueprint, and your data source (usually an Excel spreadsheet or an Outlook contact group) is the list of parts. Every time the machine runs, it stamps a different name, address, or custom field into the right spots and ships the finished product.

The most common use cases include:

  • Business correspondence: Sending personalized proposals, follow-ups, or status updates to clients
  • Marketing campaigns: Monthly newsletters with each subscriber's name in the greeting
  • HR communications: Offer letters, onboarding instructions, or performance review reminders
  • Event invitations: Wedding invites, conference confirmations, or class reunion announcements
  • Invoicing: Sending billing statements with individual account details

The best part? Once you learn this workflow, you can repeat it in minutes. The setup takes a little time the first time around, but after that, you'll be spinning out personalized bulk emails faster than you can refresh your inbox.

What You Need Before You Start

Before we dive into the steps, let's make sure you have everything in place. Missing any of these will cause the process to stall or produce garbled results:

  • Microsoft Word (2016, 2019, 2021, or Microsoft 365), This is where you'll build your email template and run the merge
  • Microsoft Outlook, Mail merge emails are sent through Outlook, not a browser-based email client. Gmail or Yahoo won't work here without third-party add-ins
  • A data source, This is typically an Excel spreadsheet (.xlsx), a Word table, or an Outlook Contacts folder. Excel is by far the most flexible and commonly used
  • A finalized recipient list, Clean, proofread data. Mail merge will faithfully reproduce any typos in your spreadsheet, so sort out errors now
Tip: If you're using Microsoft 365 (the subscription version), make sure Outlook is set as your default mail application on Windows. Word hands off the send job to Outlook, so if Outlook isn't configured, emails will either fail silently or throw an error.

Step-by-Step: How to Send Email Through Mail Merge

Step 1
Prepare Your Data Source in Excel

Your data source is the engine behind every personalization in your email. Open Microsoft Excel and create a new spreadsheet. The first row must be your header row, these header names will become the merge field names you insert into your Word template.

A typical email merge spreadsheet might look like this:

  • Column A: FirstName
  • Column B: LastName
  • Column C: EmailAddress
  • Column D: CompanyName
  • Column E: OrderTotal

A few critical rules for your spreadsheet:

  • Use single-word or CamelCase column headers (no spaces, use FirstName not First Name)
  • Make sure every row has a valid email address in the email column
  • Remove any blank rows in the middle of your data
  • Save the file and close it before starting the merge, Word can't read the file if Excel has it locked open
Warning: If your Excel file has multiple sheets, Word will only read from the first sheet (Sheet1) by default. Make sure your data is on Sheet1, or rename the sheet you want to use and select it during the connection step.
Step 2
Open Microsoft Word and Start the Mail Merge Wizard

Open a new blank document in Microsoft Word. You're going to use this as your email template. Don't start typing your email content yet, first, let's connect the merge engine.

There are two ways to start a mail merge:

Method A, The Step-by-Step Wizard (recommended for beginners):

  1. Click the Mailings tab in the ribbon at the top
  2. Click Start Mail Merge
  3. Select Step-by-Step Mail Merge Wizard… from the dropdown
  4. A task pane will appear on the right side of your screen, this is your guided walkthrough

Method B, Direct ribbon approach (faster once you know the workflow):

  1. Click the Mailings tab
  2. Click Start Mail Merge → E-mail Messages

Either way, once you've selected E-mail Messages as your document type, Word knows this merge is destined for Outlook rather than a printer.

Step 3
Connect Your Excel Data Source

Now you need to link your Word template to your Excel spreadsheet:

  1. In the Mailings tab, click Select Recipients
  2. Choose Use an Existing List…
  3. Browse to your Excel file and click Open
  4. A dialog box will appear asking which sheet to use, select the correct sheet and click OK
  5. Leave the "First row of data contains column headers" checkbox checked

Once connected, most of the Mailings ribbon options will become active. You'll also notice that the document still looks blank, that's fine. The connection is established in the background.

Tip: After connecting, click Edit Recipient List in the Mailings tab. This opens a dialog where you can sort, filter, or uncheck specific rows. For example, you can filter to only send to recipients in a certain city, or exclude rows where a column is blank. This is incredibly powerful for targeted sends.
Step 4
Write Your Email Template and Insert Merge Fields

Now comes the fun part, writing your personalized email. Type your message just as you would any normal email, but wherever you want personalized data to appear, you'll insert a merge field instead of typing a name or value.

To insert a merge field:

  1. Place your cursor where you want the personalized data (e.g., after "Dear ")
  2. In the Mailings tab, click Insert Merge Field
  3. Select the field name from your spreadsheet (e.g., FirstName)
  4. The field appears in your document as «FirstName», the double angle brackets indicate it's a live merge field

A sample email body might look like this:

Dear «FirstName»,

Thank you for your recent order with «CompanyName». Your order total of «OrderTotal» has been confirmed and is scheduled for delivery within 3–5 business days.

Please don't hesitate to reach out if you have any questions.

Best regards,
The Support Team

You can insert as many merge fields as you need. You can also use merge fields in the subject line, we'll cover that in the next step.

Warning: Don't type the field names manually with angle brackets. Always use the Insert Merge Field button. Manually typed field names won't merge, they'll appear as literal text in every email.
Step 5
Preview Your Merged Emails

Before sending anything, always preview. This is your safety net, it lets you catch formatting issues, missing data, or awkward phrasing before 500 people see it.

  1. In the Mailings tab, click Preview Results
  2. Your document will now show the actual data from your first recipient, replacing all merge fields with real values
  3. Use the navigation arrows (◀ ▶) next to the Preview Results button to scroll through different recipients
  4. Check a few records in the middle and end of your list, not just the first one

Look out for:

  • Extra spaces around merge fields (e.g., "Dear John" with two spaces)
  • Fields showing blank where data is missing
  • Formatting inconsistencies (some names in ALL CAPS if your data is inconsistent)
  • Currency or number fields that need formatting

Click Preview Results again to toggle back to the merge field view if you need to make edits.

Step 6
Finish and Send Your Emails Through Outlook

Once you're satisfied with the preview, it's time to send:

  1. In the Mailings tab, click Finish & Merge
  2. Select Send E-mail Messages… from the dropdown
  3. A dialog box titled "Merge to E-mail" will appear with three fields:
  • To: Select the column in your spreadsheet that contains email addresses (e.g., EmailAddress)
  • Subject line: Type your email subject here. You can include merge fields in the subject, just type them with the exact field name in angle brackets (e.g., Your order from «CompanyName» is confirmed). Note: Subject line merge fields work differently, you type them directly in this box
  • Mail format: Choose HTML (recommended for formatted emails), Plain text, or Attachment
  1. Under "Send records," choose All (to send to everyone), Current record (to send just the one you're previewing), or a range by number
  2. Click OK

Word will now pass each email to Outlook's outbox. Depending on your Outlook settings, emails may send immediately or queue in the Outbox until you manually send/receive. Check your Sent Items folder to confirm delivery.

Tip: For large sends (500+ emails), consider sending during off-peak hours to avoid triggering spam filters or hitting Microsoft's sending limits. If you're using Microsoft 365, the daily send limit is 10,000 recipients per day for most plans.

Advanced Troubleshooting

Even with everything set up correctly, mail merge can throw curveballs. Here are the most common issues and exactly how to fix them:

Problem: "Word could not merge the main document with the data source"

This generic error usually means the connection to your Excel file broke, often because the file was moved, renamed, or is still open in Excel. Close your Excel file completely, then re-establish the connection via Mailings → Select Recipients → Use an Existing List and browse to the file again.

Problem: Number and currency fields show too many decimal places or lose formatting

Excel stores numbers as raw values; Word doesn't automatically apply currency or date formatting. To fix this, you need to add a format switch directly to the merge field:

  1. Right-click the merge field in Word (e.g., «OrderTotal»)
  2. Select Toggle Field Codes
  3. You'll see something like { MERGEFIELD OrderTotal }
  4. Edit it to add a format switch: { MERGEFIELD OrderTotal \# "$#,##0.00" }
  5. Right-click again and select Toggle Field Codes to return to normal view
  6. Press F9 to refresh and preview the formatted value

Common format switches:

  • Currency: \# "$#,##0.00"
  • Date: \@ "MMMM d, yyyy"
  • Percentage: \# "0.00%"

Problem: Dates appear as numbers (e.g., 45123 instead of April 15, 2024)

Excel stores dates as serial numbers internally. When Word reads them without formatting, you get the raw number. Use the date format switch described above: right-click the date merge field, toggle field codes, and add \@ "MMMM d, yyyy" after the field name.

Problem: Emails go to the Outbox but never send

This typically means Outlook is in offline mode or isn't set as the default mail client. Check:

  1. Open Outlook → look for "Working Offline" in the bottom status bar. If present, click Send/Receive → Work Offline to toggle it off
  2. Go to Windows Settings → Apps → Default Apps → scroll down to Email and make sure Microsoft Outlook is selected
  3. Restart Outlook and trigger a manual send/receive with F9

Problem: Emails are sending but going to spam for recipients

Bulk email from a desktop client can trigger spam filters, especially at higher volumes. To reduce spam placement:

  • Avoid words like "FREE," "URGENT," or excessive exclamation marks in your subject line
  • Make sure your "From" name and reply-to address are professional and recognized by recipients
  • Keep image-to-text ratio balanced (don't send image-only emails)
  • For large campaigns, consider using a dedicated email marketing service (Mailchimp, Constant Contact, or Outlook's built-in Campaign feature in Microsoft 365) instead of the Word/Outlook merge

Problem: Mail merge works but some recipients get someone else's data

This can happen if your Excel file has inconsistent row breaks or hidden rows. Open the Excel file, select all data, and use Data → Filter to check for hidden rows. Also check for merged cells in Excel, these confuse Word's data reader significantly. Unmerge all cells before using the file as a data source.

Problem: "There is no email account configured in Outlook" error

Word found Outlook but it isn't set up with an email account yet. Open Outlook → go to File → Add Account and add your email address. You'll need your email provider's SMTP and IMAP/POP3 settings if it's not a Microsoft 365 or Hotmail account.

How to Prevent Mail Merge Problems in the Future

Once you've gotten mail merge working, a few good habits will keep your future sends smooth and stress-free:

Keep a Master Template Document

After successfully completing a mail merge, save your Word template (without the data connection) as a reusable .docx file. Name it something like MonthlyNewsletter_Template.docx. Next time, you just open the template, reconnect your updated spreadsheet, and you're off to the races.

Maintain a Standardized Data Spreadsheet Format

Create a "master format" Excel template with your standard column headers and stick to it. If every campaign uses the same column names (FirstName, EmailAddress, CompanyName, etc.), you won't have to re-insert merge fields each time. Your Word template will connect and map automatically.

Always Clean Your Data Before Merging

Before any send, run a quick audit of your spreadsheet:

  • Use Excel's Data → Remove Duplicates to eliminate duplicate email addresses
  • Use =ISNUMBER(FIND("@",C2)) to check that every email address contains an @ symbol
  • Use =PROPER(A2) to normalize names to Title Case if your data is inconsistently formatted
  • Filter for blank cells in the EmailAddress column and remove those rows

Do a Test Send to Yourself First

Before every bulk send, go to Edit Recipient List and temporarily uncheck everyone except yourself (or a test row with your own email). Run the full merge to yourself. Check that formatting looks correct, links work, and personalization is accurate. Then re-enable all recipients and send for real.

Use BCC or a Dedicated Sending Account for Large Lists

For privacy reasons, mail merge sends each email individually (which is great, recipients don't see each other's addresses). But for very large lists, consider using a dedicated "send from" address that isn't your primary work inbox. This protects your deliverability reputation if any bounces or spam complaints come back.

Document Your Sending Limits

Know your Outlook sending limits before you schedule a large campaign. Microsoft 365 Business accounts are limited to 10,000 recipients per 24 hours and 30 messages per minute. If you're on a legacy Exchange account, limits may be lower. Exceeding these limits can temporarily lock your sending ability, plan large sends over multiple days if needed.

Frequently Asked Questions

Can I do a mail merge with Gmail instead of Outlook?

Not natively through Microsoft Word. Word's mail merge email feature is built exclusively around Outlook as the mail client. If you use Gmail, you have two options: (1) Use a Google Sheets + Gmail add-on like "Yet Another Mail Merge" (YAMM) or "Mail Merge with Attachments," which replicate the same workflow entirely within Google's ecosystem; or (2) add your Gmail account to Outlook as an IMAP account, then set it as your default Outlook profile before running the Word merge. The second option works well and lets you use the full Word merge feature set while sending through Gmail's servers.

Can I include attachments in a mail merge email?

Unfortunately, Microsoft Word's built-in mail merge doesn't support adding attachments to merged emails, it's one of the most commonly requested features that still isn't natively available. There are workarounds: (1) Use a Word macro (VBA) to loop through your data and send emails with attachments via Outlook's object model; (2) Use a third-party add-in like "Mail Merge Toolkit" by MAPILab, which adds attachment support directly to the merge wizard; or (3) switch to a dedicated mail merge service like Mailchimp, HubSpot, or Sendinblue that natively supports per-recipient attachments.

How do I add a personalized subject line to each email?

When you click Finish & Merge → Send E-mail Messages, a dialog box appears with a Subject line field. You can type a static subject line here, or include a merge field by typing it manually with double angle brackets, for example: Your invoice for «CompanyName» is ready. Note that unlike the body of your email where you use the Insert Merge Field button, in the subject line dialog you type the field name directly. Make sure the field name matches your spreadsheet header exactly, including capitalization.

Can I use a conditional statement so different recipients get different content?

Yes, Word supports conditional merge fields called "If...Then...Else" rules. To insert one: go to Mailings → Rules → If...Then...Else. You can set it up to say something like: "If MembershipTier equals 'Gold', insert [premium offer text], otherwise insert [standard offer text]." This is extremely powerful for segmented campaigns where different groups should see different messaging. You can nest multiple conditions to create quite sophisticated personalization logic, all within a single template.

Why do I see «NextRecord» fields scattered through my document?

The «Next Record» field is used in label and directory merges to advance to the next row of data within a single page. If you're seeing these in an email merge template, they shouldn't be there, they'll cause Word to skip records, meaning some recipients will never get an email. Select and delete every «Next Record» field from your email template. This issue usually creeps in when someone starts with a label template and converts it for email use, or accidentally inserts the field from the Rules menu.

How do I know if my merged emails were actually delivered?

Word doesn't give you delivery reports, once it hands the emails off to Outlook, you're relying on Outlook's standard send confirmation. You can check your Outlook Sent Items folder to verify emails were dispatched (each email shows up individually, so you can see the personalized version of each). For actual delivery confirmation, you'd need to enable read receipts before sending (go to File → Options → Mail → Tracking in Outlook), though recipients can decline these. For serious bulk email campaigns where delivery rates matter, a dedicated email marketing platform with real bounce tracking and open rate analytics is a better long-term investment than Word/Outlook merge.

Can I use Outlook contacts directly instead of an Excel spreadsheet?

Yes, absolutely. When selecting your data source in Word, choose Mailings → Select Recipients → Select from Outlook Contacts. Word will connect directly to your Outlook Contacts folder (or any subfolder/contact group you choose). The available merge fields will be drawn from your Outlook contact field names (First Name, Last Name, Email Address, Company, etc.). This is convenient if your contact list already lives in Outlook and you don't want to maintain a separate Excel file. The limitation is that Outlook contacts don't support custom fields as flexibly as a spreadsheet, if you need custom data columns (like order totals or account numbers), Excel is the better choice.

My merged emails look different on mobile than on desktop, why?

Mail merge emails sent as HTML from Word inherit Word's HTML rendering quirks, and Word's HTML is notoriously heavy with inline styles that don't always translate cleanly to mobile email clients. Common issues include fixed-width tables that overflow on small screens, fonts that render differently on iOS vs. Android, and spacing issues caused by Word's paragraph formatting. The practical fix: keep your email template as simple as possible. Use a single-column layout, avoid tables for layout purposes, stick to web-safe fonts (Arial, Georgia, Verdana, Times New Roman), and test your preview in both Outlook desktop and webmail before bulk sending. For mobile-optimized HTML emails, a dedicated email platform will always give better results than Word's HTML output.

You're Ready to Merge

Mail merge might have a reputation as a "power user" feature, but as you've seen, the core workflow is really just six steps: prepare your data, open Word, connect the spreadsheet, write your template, preview the results, and send. Once you've done it once, the whole process takes less than ten minutes for most campaigns.

The key things to remember: always clean your data before you merge, always preview before you send, and always test on yourself first. Those three habits alone will save you from 90% of the embarrassing bulk email mistakes that happen out in the wild, the ones where 300 customers get an email that says "Dear «FirstName»" because someone skipped the preview step.

Now go build that spreadsheet, write that template, and let Outlook do the heavy lifting.

Quick Recap: Mailings tab → Start Mail Merge → E-mail Messages → Select Recipients → Insert Merge Fields → Preview Results → Finish & Merge → Send E-mail Messages. That's the whole workflow in one line.