Mail merge in Outlook works by connecting your email to a list of names and addresses, then automatically filling in details like each person's name or company into the same message template

Outlook itself does not have a built-in mail merge feature the way Word does. Instead, you use Word as the document where you write your message template, then connect it to Outlook to send. This means you write once, set up your data list once, and Outlook handles sending individual copies to each person on that list with their specific details filled in.

The process takes about 15 to 20 minutes to set up the first time, and most of that time is organizing your contact list. Once you understand the steps, you can reuse the same template for future campaigns by just swapping in a new contact list.

Key Takeaways

  • Mail merge in Outlook requires Word as your message editor and a data source (usually an Excel spreadsheet or CSV file) with your contact information organized in columns.
  • You create a mail merge document in Word by inserting merge fields like <<FirstName>> and <<Company>> into your message template.
  • Word handles the actual sending through Outlook, not Outlook directly, so you need both programs open and working together.
  • Your contact list must have column headers in the first row (Name, Email, Company, etc.) or the merge will not recognize your data.
  • You can preview exactly what each person will receive before sending, which catches mistakes in your template or data.

Prepare your contact list in Excel or as a CSV file

Start by organizing the names, email addresses, and any other details you want to personalize into a spreadsheet. Open Excel and create columns with headers in the first row: Email, FirstName, LastName, Company, or whatever fields you plan to use in your message. Each person gets one row below the headers.

Save this file as an Excel workbook (.xlsx) or as a CSV file (comma-separated values). CSV works with almost any mail merge setup and is the safest choice if you are unsure. Do not leave blank cells in the middle of your list — if you have 50 people, rows 1 through 51 should be filled, with no empty rows between them. Word will stop merging the moment it hits a blank row.

Double-check that email addresses have no extra spaces before or after them. A space at the end of an email address will cause the message to bounce. If you are copying from another source, paste into a text editor first, then copy from there into Excel to strip out hidden formatting.

Open Word and set up your mail merge document

Create a new blank document in Word. Write your message as you normally would, but leave placeholders where you want personalized details to appear. For example: "Hi <<FirstName>>, thank you for your interest in <<Company>>." Do not type the angle brackets yourself — you will insert merge fields instead.

Go to the Mailings tab at the top of Word. Click Start Mail Merge, then choose Email Messages from the dropdown. This tells Word you are sending email, not printing letters.

Next, click Select Recipients and choose Use an Existing List. Browse to your Excel or CSV file and open it. Word will ask which sheet to use if your file has multiple sheets — pick the one with your contact data. You should now see your spreadsheet data loaded into Word.

Insert merge fields into your message template

Click in your message where you want the first personalized detail to appear. Go to Mailings and click Insert Merge Field. A dropdown menu shows all the column headers from your spreadsheet. Click the one you want — for example, FirstName. Word inserts <<FirstName>> into your message.

Repeat this for each field you want to personalize. If your message says "Hi <<FirstName>> at <<Company>>," you have inserted two merge fields. You can insert the same field multiple times if you need it in different places.

Format your message normally — bold, italics, font size, colors all work fine. The merge fields will inherit the formatting around them. If you want a merge field in bold, select it and press Ctrl+B before inserting it, or bold it after insertion.

Preview your messages before sending

Click Preview Results in the Mailings tab. Word now shows you what the first person's actual message will look like, with their real name and company filled in instead of the merge field placeholders. Use the arrow buttons to scroll through a few examples and make sure everything looks correct.

Look for common problems: names that are capitalized wrong, email addresses with spaces, missing punctuation around merge fields, or fields that did not populate at all. If you spot an error in the data, click Edit Recipient List to fix it directly in Word without going back to your spreadsheet.

Once you are satisfied, click Preview Results again to turn off the preview and go back to seeing the merge field placeholders.

Send your messages through Outlook

Go to Mailings and click Finish & Merge, then choose Send Email Messages. A dialog box appears asking which field contains the email addresses. Select the column header that has your email addresses — usually Email. Click OK.

Another dialog asks which records to send to. Choose All to send to everyone, or From and To if you want to send to only a range of rows. Click OK. Word now opens Outlook and queues up all your messages.

Outlook will show you a progress bar as it sends. Depending on how many messages you are sending and your internet connection, this can take a few minutes. Do not close Outlook or Word until the progress bar finishes. Once complete, your messages are in Outlook's Sent folder.

Troubleshoot common problems

Messages are not sending: Check that Outlook is your default email program. Go to Settings > Apps > Default Apps and set Outlook as your default email client. If Outlook is already set as default, close both Word and Outlook completely, then try again.

Merge fields show as <<FieldName>> instead of actual data: This usually means Word did not connect to your data source properly. Click Select Recipients again and re-browse to your file. You may also need to click Edit Recipient List and make sure the data is showing in the preview.

Some emails have blank fields or show "Error! Not a valid merge field": Check your spreadsheet for blank cells in that column, or for a column header that does not match exactly what you typed in the merge field. Column headers are case-sensitive — <<firstname>> is different from <<FirstName>>.

Outlook is sending but messages are bouncing: Check for extra spaces in your email addresses. Open your Excel file, click on an email cell, and look at the formula bar at the top to see if there are spaces before or after the address. Use Find & Replace to remove them: Ctrl+H, search for " " (space), replace with nothing.

Frequently Asked Questions

Can I add a subject line that changes for each person?

Yes. In the Finish & Merge dialog, before you click Send Email Messages, you will see a field for "Subject line." You can type a static subject, or click the button next to it to insert a merge field. This lets you personalize the subject the same way you personalize the body.

What if I want to send to only some people on my list, not everyone?

When the Finish & Merge dialog appears, choose the "From" and "To" option instead of "All," then enter the row numbers you want to send to. Row 1 is your header, so your first contact is row 2. If you want to send to contacts 5 through 15, enter From 6 To 16.

Can I attach a file to a mail merge email?

Not directly through the mail merge dialog. Instead, attach your file to the template message in Word before you start the merge. The attachment will be included in every message sent. If different people need different attachments, mail merge is not the right tool — you would need to send individual emails or use a third-party service.

Do I need to keep my Excel file open while sending?

No. Once you have selected your data source in Word, the data is loaded into Word's memory. You can close Excel. Keep the Word document open until the merge is complete, though.

Can I save the merged messages before sending them?

Yes, but it creates a separate document for each person. Instead of clicking "Send Email Messages," click "Merge to New Document." Word creates one large document with each person's message on a separate page. You can then review, edit, or print them. To send from this merged document, you would need to copy each message manually into Outlook, which defeats the purpose of mail merge.