EmailNa

Home › For senders

How to mail merge in Outlook

Outlook can send a personal email to everyone on a list, with their own name in it. You write it in Word, pick an Excel list, and classic Outlook sends one email per person. New Outlook works differently, and attachments need a workaround.

By David Ray · Updated October 30, 2026 · 5 min read · How we research

Quick answer

In Word, go to Mailings › Start Mail Merge › E-mail Messages, choose your Excel list with Select Recipients › Use an Existing List, add fields, then click Finish & Merge › Send E-mail Messages. It sends through classic Outlook only. New Outlook has a basic Start mail merge option instead, and neither lets you attach files.

Which Outlook do you have?

Microsoft now has two Outlook apps for Windows, and mail merge works differently in each:

If you have new Outlook, you can usually switch back by turning off the New Outlook toggle at the top right. Work accounts may have this controlled by IT.

Mail merge from Word to Outlook (classic)

You need your list in Excel (or a CSV), Word, and classic Outlook signed in to the account you want to send from. Make classic Outlook your default email app.

  1. Open Word and go to Mailings › Start Mail Merge › E-mail Messages.
  2. Click Select Recipients › Use an Existing List, open your Excel file, pick the sheet, and click OK. The sheet needs a column of email addresses.
  3. Type your email in the Word page. Add personal details with Greeting Line (for "Dear Jane,") or Insert Merge Field (for any column, like «Company»).
  4. Click Preview Results and use the arrows to check a few people.
  5. Click Finish & Merge › Send E-mail Messages.
  6. Set To to your email column and type the Subject line. Choose HTML for formatted text or Plain text. Under Send records, test first with Current record.
  7. Click OK. Outlook sends one separate email to each person. Each person sees only their own address.

Can't do the spreadsheet part? Our step-by-step guide on mail merge from Excel to Word covers setting up the sheet, labels and letters, and fixing dates and ZIP codes.

The subject line is the same for everyone in Word's merge: you can't put a merge field in it. If you need a personal subject, use a mail merge add-on.

Start from your Outlook contacts

In classic Outlook you can also merge straight from your contacts, without Excel:

  1. In classic Outlook, open People (or press Ctrl+3).
  2. Select the contacts you want, or a contact folder.
  3. On the Home tab, click Mail Merge. If you don't see it, look under the ... (more) menu.
  4. Under Merge options, set Document type to Form Letters and Merge to to E-mail. Type the subject in Message subject line and click OK.
  5. Word opens. Write the message, add fields, then click Finish & Merge › Send E-mail Messages.

Mail merge in new Outlook

Here is where it gets confusing. Microsoft's own feature comparison lists mail merge as only "Partially Available" in new Outlook. In practice:

If you're stuck on new Outlook today, you have two options: switch back to classic Outlook for the merge, or use a mail merge add-on from the Outlook add-ins store.

Can you add attachments?

Not with Word and Outlook's built-in mail merge. Microsoft's help page says it plainly: you can't add attachments, but you can include links. Your options:

Sending limits

Outlook sends each merged email as a normal email from your account, so your account's limits apply:

AccountLimit
Outlook.com with Microsoft 3655,000 recipients a day, 500 per email, and 1,000 people a day you haven't emailed before
Outlook.com freeLower; Microsoft doesn't publish the numbers
Work or school accountSet by your organization; ask IT

A merge to a list full of old or mistyped addresses bounces a lot, and many bounces in one day can get your account limited. Check the list before you send.

Sending the same email one at a time instead? An Outlook email template may be all you need.

If it doesn’t send

Questions people ask

How do I mail merge in Outlook?
Use Word: Mailings, Start Mail Merge, E-mail Messages. Pick your Excel list with Select Recipients, add fields, then click Finish & Merge, Send E-mail Messages. Classic Outlook sends one email to each person.
Does mail merge work in new Outlook?
Only partly. Word's email merge does not send through new Outlook. New Outlook has a basic Start mail merge option that sends a separate copy to each person, but without personal fields like their name.
Can I add an attachment to a mail merge in Outlook?
Not with the built-in mail merge. Put a link to the file in the email, or use a paid Outlook add-on that supports attachments.
Will recipients see each other's addresses?
No. A mail merge sends a separate email to each person, so they only see their own address.
How many emails can I mail merge in Outlook?
Your account's limit applies. Outlook.com with Microsoft 365 allows 5,000 recipients a day; free accounts get less. Work accounts follow your organization's limits.