How to Do a Mail Merge in Outlook Using the Built-in Method and Beyond

What is mail merge in Outlook?

Mail merge lets you send a personalized version of the same email to many people. Instead of typing each email separately, you create one template with placeholders and fill them from a data source like Excel.

A simple example. Your spreadsheet has columns for first name, last name, email, and amount due. Your template addresses each person by name and includes their specific data from the sheet. Outlook sends each person their own version. Simple.

This works for billing reminders, event invitations, membership renewals, and client updates. But the built-in tool has limits that sneak up on you. Depending on your list size and whether you need attachments, the free method can cost more in time than a paid tool.

A typical setup involves an Excel sheet with names and email addresses, and a Word document with placeholders. When you run the merge, Outlook processes each row individually. The result looks professional, but getting there can be a painful experience if your list is large or if you need anything beyond basic text personalization.

People search for "how to mail merge in Outlook" every day, and most of them land on Microsoft's official documentation first. That documentation shows the happy path. It does not show what happens when your merge freezes at recipient 47 or when you realize attachments are not supported. This guide covers both the official method and the practical alternatives.

The built-in method: Word Mail Merge with Outlook

Microsoft's mail merge runs through Word. You write your template there, connect it to your Excel data, and send through Outlook.

Here is how it works.

First, prepare your data. Open your contact list in Excel. The first row must be column headers. Name your email column "Email" or "E-mail Address" so Outlook can find it.

Open Word and go to Mailings > Start Mail Merge > E-mail Messages. This tells Word you are sending emails, not printing labels.

Select Recipients > Use an Existing List. Pick your Excel file and the sheet with your contacts. Word shows you the data in a table.

Write your template in the Word document. Where you want personalization, click Insert Merge Field and pick the column. It shows up as a placeholder.

Click Preview Results to check a few recipients and make sure the personalization looks right. Then click Finish & Merge > Send E-mail Messages. Word asks for the subject line and which column has the email address.

Hit send and wait. Word sends each email through your Outlook session. This can take anywhere from a few minutes to an hour. Outlook might freeze. There is no progress bar and no way to resume if it fails halfway. You start over.

Where the built-in method falls short

Word Mail Merge was designed in a different era. It was built for printing envelopes and form letters, not for sending professional email campaigns. The limitations become obvious fast.

No attachments. This is the biggest one. Word Mail Merge cannot attach files. Each recipient gets the email body only. No invoices, no contracts, no statements. If you need attached documents, you cannot use the built-in tool. Period. This is the single most common reason people look for alternatives. In fact, if you search online for "mail merge with attachments outlook," almost every result points to a third-party tool rather than a built-in solution.

Frequent freezing. Word and Outlook were not built to coordinate hundreds of email sends. Users regularly report Outlook freezing, ghost drafts piling up in the Outbox, and Word stopping partway through. Recovery means restarting and hoping it works this time.

Hard limit around 50 to 100 recipients. Exchange Online throttles connections when it sees too many emails too fast. The merge stalls. Some emails go through, others do not. You have no way to tell who got theirs and who needs a followup. For billing or deadline communications, that uncertainty is a problem. There is no dashboard, no log, and no way to resume from where it stopped. You guess, you follow up manually, and you hope you caught everyone.

One attachment for everyone. Even if you find a workaround, Word Mail Merge sends the same file to every recipient. If client A needs invoice 001 and client B needs invoice 002, you are out of luck. Each one goes manually. There is no way around this within the built-in tool. You either accept it or switch to something else.

A better approach: FlowDrafts

FlowDrafts replaces the mail merge process with an add-in that lives inside Outlook. It solves the limitations above while keeping your data on your machine.

Here is how the same workflow works with the add-in.

Open a new message in Outlook. The FlowDrafts tab appears in the ribbon. Click Activate.

Copy your data from Excel. The format is simple: company name, contact name, email address. You can include multiple contacts per company. Paste the data into the Recipients tab in the FlowDrafts task pane and click Parse Data. The add-in reads your columns and builds a structured list.

Switch to the Message tab. Write your email. Use the tag buttons to insert personalization: recipient name, company name, or any custom field. Configure the greeting logic for cases where a name might be missing.

If you need to attach documents, go back to the Recipients grid. Each row has a folder icon. Click it and select the file for that specific recipient. The grid shows you every pairing visually. You see who gets what before anything is sent. This eliminates the risk of attaching the wrong document to the wrong person, which is the most common and most damaging mistake in manual email distribution.

When you are ready, check the "Recipients verified" and "Message verified" boxes in the footer. Click Send Selected. Each person gets their own email with their specific documents. The add-in paces the sends so Outlook never stalls.

After the campaign, click the Logs button in the ribbon to see a detailed history. Export to CSV for your records.

The whole process takes about five minutes for 100 recipients. Most of that time is spent confirming the attachments are right. Next time, your template is saved.

Comparison: Word Mail Merge vs VBA vs FlowDrafts

The right choice depends on what you need. Word Mail Merge works for text-only emails under 50 people. VBA works if you can code and do not mind maintaining scripts. FlowDrafts works when you need attachments, send to more than 50 people regularly, want an audit trail, or care about keeping data off the cloud.

Word Mail Merge is fine for simple tasks. But it was not built for the kind of email work that professionals do today. Unique attachments, per-recipient personalization, reliable delivery at scale, and data privacy are requirements the old tool cannot meet.

FlowDrafts was built to fill that gap. It gives you the simplicity of a mail merge with the power of a professional tool, all inside Outlook, all on your machine.