You need to send the same letter, invitation or certificate to 50 people, each with their own name and details. Typing each one by hand would take hours and invite mistakes. Mail merge in Word does it automatically: you write the document once, connect a list of names, and Word creates a personalized copy for every person. This guide shows you how to do a mail merge in Word step by step, using an Excel list.
The steps below work in Word for Microsoft 365, Word 2021 and Word 2019 on Windows. Word for Mac has the same features under the Mailings tab. Word for the web doesn’t support mail merge.
What you need before you start
- The Word document you want to personalize, such as a letter or certificate.
- A list of recipients, usually an Excel file. Outlook contacts and Word tables also work.
Prepare your Excel list
Most mail merge problems come from the list, so spend a few minutes here:
- Put the data on the first sheet, starting in cell A1.
- Use one header row with short, clear names: FirstName, LastName, Email, Address, City.
- No blank rows in the middle and no merged cells.
- Save and close the Excel file before connecting it. Word sometimes can’t read a workbook that’s open.
If your list has repeated people, clean it first with our guide on how to remove duplicates in Excel, or everyone on the list twice will get two letters.
How to do a mail merge in Word, step by step
Step 1: Choose the document type
- Open your document in Word, or start a new one.
- Go to the Mailings tab and click Start Mail Merge.
- Choose Letters for letters, certificates and most documents. Choose E-mail Messages to send personalized emails through Outlook, or Labels and Envelopes for mailing labels.
Step 2: Connect your list
- Click Select Recipients > Use an Existing List.
- Find your Excel file and click Open.
- Choose the sheet with your data (usually Sheet1$), make sure First row of data contains column headers is ticked, and click OK.
To send to only some people, click Edit Recipient List. You can untick names, sort the list, or use Filter to include only rows that match a condition, such as City equals Chicago.
Step 3: Insert the merge fields
Merge fields are placeholders that Word fills with each person’s data.
- Click where you want the name to appear, for example after “Dear”.
- Click Insert Merge Field and choose FirstName.
- Repeat for every detail you want to personalize.
The fields appear as «FirstName». Type spaces and punctuation around them as normal text, for example: Dear «FirstName» «LastName»,
For addresses, Address Block and Greeting Line insert a full, formatted address or greeting in one go. They’re handy, but individual fields give you more control.
Step 4: Preview the results
Click Preview Results. Word replaces the fields with real data from the first person on the list. Use the arrows next to it to check several records, especially ones with long names or missing information.
Step 5: Finish the merge
Click Finish & Merge and choose one option:
- Edit Individual Documents: creates a new Word document with one page or section per person. This is the safest choice, because you can review everything and save it as a PDF.
- Print Documents: sends everything straight to the printer.
- Send Email Messages: sends each email through Outlook. Pick the Email column in the To box and type a subject line.
Fixing common mail merge problems
Numbers, dates or prices look wrong
Word often ignores Excel’s formatting, so 25 might appear as 25.000000001 or a date might show in a different order. The simplest fix is to format those columns as text in Excel, or create a helper column with a formula like =TEXT(B2,"$#,##0.00") or =TEXT(C2,"mmmm d, yyyy"), and merge that column instead.
Blank lines where data is missing
If some people have no second address line, you’ll get an empty gap. Address Block handles this automatically. With individual fields, use Rules > If…Then…Else to show text only when the field has a value.
Word can’t open the Excel file
Close the workbook in Excel and try again. If it still fails, save the list as a new .xlsx file with the data starting in A1.
Emails aren’t sending
Mail merge emails need the classic Outlook desktop app set as your default email program. The new Outlook for Windows and webmail accounts don’t support Word’s Send Email Messages option.
Tips for a professional result
- Send a test first. Put your own name and email as the first row and merge only that record.
- Save the main document. Next time, open it, check the list connection and merge again.
- Export to PDF when sharing certificates or letters, so formatting stays fixed. Our guide to making a resume in Word shows how.
FAQ
Can I do a mail merge without Excel?
Yes. In Select Recipients, choose Type a New List to create a list inside Word, or use Choose from Outlook Contacts. Excel is just the most common and flexible option.
Can I mail merge in Google Docs?
Google Docs doesn’t have a built-in mail merge like Word. Gmail offers a mail merge feature on some Google Workspace plans, and add-ons can merge Google Sheets data into Docs.
How do I save each merged letter as a separate PDF?
Word’s built-in merge creates one combined document. To get one PDF per person you’ll need a macro or a third-party add-in, or you can split the combined PDF with a free tool like PDF24.
Does mail merge work in Word for the web?
No. Mail merge requires the Word desktop app for Windows or Mac.
