Mail Merge in Outlook — the Native Way vs the Easy Way

Published June 12, 2026 · 7 min read

There are two ways to do a mail merge in Outlook. The first is the native one Microsoft ships for classic Outlook: you drive it from Word, pull recipients from an Excel sheet, and let Outlook do the sending. The second is to skip the Word-and-Excel dance entirely and run the merge inside Outlook on the web with a CSV. This guide covers both — the exact native steps, the limitations nobody tells you about (attachments and tracking are the big ones), and where the easy way fits.

If you searched for "outlook mail merge with attachments" or "track mail merge outlook," you already hit the wall that brings most people here. We'll get to why, and what to do about it.

How to mail merge in Outlook the native way (Word + Excel)

For classic Outlook, the built-in method lives in Microsoft Word rather than in Outlook itself. New Outlook and Outlook on the web do have a basic Start mail merge in the Send dropdown, but it gives each recipient their own copy of the same message with no personalization (what it does today). Here's the full Word flow:

1. Build your list in Excel. One row per recipient, with columns like Email, First Name, and Company. Save and close the file.
2. Start the merge in Word. Open Word and go to Mailings → Start Mail Merge → Email Messages.
3. Select recipients. Click Select Recipients → Use an Existing List and pick your Excel file (choose the right sheet when prompted).
4. Insert merge fields. Write your message, then use Insert Merge Field to drop in First Name, Company, and any other columns where you want personalization.
5. Finish & Merge. Click Finish & Merge → Send Email Messages. In the dialog, set the To field to your email column, type a subject line, and send. Word hands each message to Outlook, which delivers them from your mailbox.

That's it — the native mail merge works, and for a one-off personalized blast it's genuinely fine. The problems start the moment you want anything more than a plain, fire-and-forget email.

The hard limitations of native Outlook mail merge

This is the part the tutorials skip. None of these are bugs you can work around with a setting — they're structural gaps in how Word's email merge works:

• No attachments. Word's email merge sends a message body and nothing else. There is simply no field for attaching a file, so you cannot attach a PDF, deck, or contract to a native mail merge. This is the single most-searched pain point — and the workarounds (VBA macros, paid add-ins) are fiddly and break easily.
• No open or click tracking. Once you hit send, you're blind. No idea who opened, who clicked, or whether anything landed at all.
• No per-recipient reporting. There's no campaign view, no bounce list, no "who engaged" — Word doesn't keep any record beyond your Sent folder.
• No scheduling. The merge sends immediately. You can't queue it for 9am Tuesday in the recipient's timezone.
• No follow-ups. Re-emailing the people who didn't open means rebuilding the whole merge by hand against a manually filtered list.
• Limited personalization. You get column substitution and basic conditional fields, but no easy unsubscribe link, no suppression list, no A/B subject testing.
• You hit send limits fast. Microsoft 365 and Outlook.com throttle how many recipients you can send to per day. A large Word merge fires messages as fast as Outlook can hand them off, with no rate control, so it trips those limits and gets the rest of the batch silently deferred — see our full breakdown of Outlook's send limits.

Native Word mail merge vs OutMass

Capability	Native Word + Outlook merge	OutMass
Where you work	Word + Excel, then Outlook	Inside Outlook on the web
Recipient source	Excel sheet	CSV upload
Personalization	Merge fields	{{firstName}}, {{company}} merge tags
Attachments	Not supported	OneDrive sharing links (larger files, better deliverability)
Open tracking	No	Yes (pixel)
Click tracking	No	Yes
Reply detection	No	Yes (inbox checked every six hours)
Per-recipient reporting	No	Reports + CSV export
Scheduling	No (sends now)	Yes
Follow-ups	No (manual rebuild)	Yes (1 stage today, to people who haven't replied, or haven't opened)
Subject A/B testing	No	Yes
Unsubscribe + suppression list	No	Yes
Resume after a partial failure	No	Yes
Cost	Included with Office	Free up to 250/mo; $9/mo Starter; $19/mo Pro

The easy way: mail merge in Outlook with OutMass

OutMass is a Chrome extension that runs inside Outlook on the web (outlook.office.com, outlook.live.com, and outlook.office365.com). It sends through your own Microsoft account via Microsoft Graph — there's no separate sending server. (Campaign subject and body are stored on our backend so scheduled sends, follow-ups and reports work; your inbox is never read.) The merge itself is the part that takes thirty seconds instead of the Word-and-Excel round trip:

1. Upload a CSV of recipients (the same email, firstName, company columns you'd put in Excel).
2. Write your message with {{firstName}}-style merge tags and preview a few rows.
3. Attach files as OneDrive links, schedule the send if you want, and turn on a follow-up for anyone who hasn't replied.
4. Send — then watch opens, clicks, and replies populate in the Reports tab.

Solving the attachment gap

This is the headline fix. Because the native merge can't attach files at all, people contort themselves with macros. OutMass sidesteps it: when you add a file, it generates a view-only sharing link from your own OneDrive and inserts it into the message. The recipient gets the file, and you can send something far larger than an email attachment limit allows. As a bonus, links don't drag your deliverability down the way a heavy attached PDF does.

Solving the tracking gap

Where the native method leaves you blind, OutMass stamps every recipient with open, click, and reply status. A Microsoft Graph check of your inbox every six hours catches replies; pixel and link tracking handle opens and clicks; and an "Engaged" metric rolls them into a single honest number. Everything exports to CSV from the Reports tab. If you want the full picture of how high-volume sending behaves from an Outlook mailbox — including the throttling math — read how to send mass emails from Outlook.

Frequently asked questions

How do I mail merge in Outlook?

In classic Outlook, the native way is Microsoft Word's Mail Merge: build a recipient list in Excel, then in Word go to Mailings → Start Mail Merge → Email Messages, select your Excel list, insert merge fields like First Name, and Finish & Merge → Send Email Messages so Word sends them through Outlook. New Outlook and Outlook on the web have a basic Start mail merge in the Send dropdown that gives each recipient their own copy of the same message, without personalization. The easier way is OutMass — a CSV-based mail merge that runs inside Outlook on the web and adds open/click tracking, scheduling, and follow-ups.

Can you mail merge with attachments in Outlook?

Not with the native Word email merge — it sends one message body to each recipient but has no field for a per-recipient file attachment, so the standard mail merge can't attach files at all. The usual workarounds rely on VBA macros or third-party add-ins and are clunky. OutMass solves it differently: it attaches files as OneDrive sharing links, which give better deliverability and allow far larger files than a native attachment.

Can you track a mail merge in Outlook?

The native Word + Outlook mail merge has no open tracking, no click tracking, and no per-recipient reporting — once you hit send, you're blind. OutMass adds pixel open tracking, click tracking, reply detection that checks your inbox every six hours, and a per-recipient reports view you can export to CSV.

Why do mail merge emails from Outlook go to spam?

Common causes are sending too many messages too fast, spammy subject lines or content, and large file attachments. The native Word merge has no throttle, so it can outrun Microsoft's documented 30-messages-per-minute send rate on Exchange Online (Microsoft Learn) — a burst that looks like spam. OutMass sends through your own mailbox at a controlled rate and uses OneDrive sharing links instead of heavy attachments, both of which help deliverability. If raw volume is the issue, see our breakdown of Outlook and Microsoft 365 send limits.

Last updated: September 15, 2026 — named the basic mail merge built into new Outlook and Outlook on the web, and corrected the per-message, new-tenant and Outlook.com sending limits.