Mail merge is a Word feature that fills in the same template letter with different names, addresses, or other details from a list
Mail merge takes a form letter you write once and automatically swaps in different information for each person on a list. Instead of typing 50 letters with different names and addresses, you write one letter with blanks, connect it to a spreadsheet or database of names and addresses, and Word fills in each blank for each person. The result is 50 personalized letters that look like you wrote them individually.
The feature is built into Microsoft Word and works with data stored in Excel spreadsheets, Outlook contacts, or plain text files. It is most useful when you need to send the same message to many people but want each copy to include their specific information — a landlord sending lease renewal notices to 20 tenants, a small business sending invoices with customer names, or a nonprofit sending donation receipts.
Key Takeaways
- Mail merge requires two files: a template letter in Word and a data source (usually an Excel spreadsheet) with the names and details you want to insert.
- You mark the spots in your letter where information should change using merge fields, which Word pulls from your data source automatically.
- Word can create individual documents, print all letters at once, or send them as email messages — depending on what you need.
- The data source must be organized in columns (one column for first names, one for addresses, one for email addresses, and so on) for merge fields to work correctly.
Setting up your data source
Before you start in Word, organize your information in a spreadsheet. Open Excel and create a table with column headers in the first row. The first column might be "First Name", the second "Last Name", the third "Address", and so on. Each row below the headers is one person. Make sure the spelling and capitalization of the headers are exact — Word will look for these names when you insert merge fields.
Save the spreadsheet as an Excel file (.xlsx) or as a CSV file (comma-separated values), which Word can also read. Do not leave blank rows in the middle of your data, and do not include extra formatting like bold or colored cells — Word only reads the text itself. Once the spreadsheet is saved, you are ready to move to Word.
Creating the template letter in Word
Open Word and write your letter as you normally would. Type the body of the message, the closing, and anything else that stays the same for every recipient. Leave blank spaces where you want the personalized information to go — for example, leave a blank line where the recipient's name should appear at the top.
Do not type the actual names or addresses yet. You will tell Word to fill those in automatically using merge fields. Format the letter the way you want it to look: set margins, choose your font, add a signature line at the bottom. The only thing you are not typing is the information that changes from letter to letter.
Inserting merge fields into your template
In Word, go to the Mailings tab at the top of the screen. Click Start Mail Merge and choose the type of document you are creating — usually Letters. Next, click Select Recipients and choose Use an Existing List. Navigate to your Excel spreadsheet and open it. Word will show you a preview of the data it found.
Now click back into your letter where you want the first piece of personalized information to appear. Go to the Mailings tab again and click Insert Merge Field. A dropdown menu will show the column headers from your spreadsheet — for example, "First Name", "Last Name", "Address". Click the one you want. Word will insert a placeholder like <<First Name>> into your letter. Repeat this for each piece of information that changes. If you want the greeting to say "Dear John Smith", insert the First Name field, type a space, then insert the Last Name field.
Previewing and finishing the merge
Before you create all the letters, preview how they will look. In the Mailings tab, click Preview Results. Word will show you the first letter with actual names and addresses filled in instead of the merge field placeholders. Use the arrow buttons to scroll through a few letters and make sure everything looks right. If a name is in the wrong place or a field is missing, go back and fix your template.
Once the preview looks correct, you have three options. Click Finish & Merge to choose whether you want to edit individual documents (which creates a new Word file with all the letters so you can make changes to specific ones), print all letters at once, or send them as emails. Most people choose Edit Individual Documents so they can review the final result before printing or sending anything.
Common mistakes and how to avoid them
The most common problem is a mismatch between the merge field names in Word and the column headers in your spreadsheet. If your spreadsheet says "FirstName" but you try to insert a field called "First Name", Word will not find it. Always check that the headers in your spreadsheet match exactly what you see in the Insert Merge Field dropdown.
Another frequent issue is blank rows or extra spaces in the data source. If your Excel file has a blank row in the middle, Word will create a blank letter for that row. Clean up your spreadsheet before you start the merge. Also, if you have extra spaces before or after names in your cells (like " John " instead of "John"), those spaces will appear in your letters. Use Find & Replace in Excel to remove leading and trailing spaces if you have many entries.
When mail merge is worth the effort
Mail merge saves time only if you are sending the same message to more than about five or six people. For two or three letters, it is faster to type them individually. But if you send bulk letters regularly — monthly invoices, annual renewal notices, or event invitations — setting up mail merge once means you can reuse the template every time. You only have to organize your data source once, and then you can run the merge again whenever you have a new list of names.
Mail merge also works for labels, envelopes, and email messages, not just letters. If you need to print address labels for a mailing, you can use the same data source and merge them onto label templates that Word provides. The process is the same: connect your data, insert merge fields, and let Word fill in the rest.
Frequently Asked Questions
What if I only want to send letters to some people on my list, not everyone?
After you select your data source, click Edit Recipient List in the Mailings tab. Word will show you all the names from your spreadsheet with checkboxes. Uncheck the people you do not want to include, then close the dialog. The merge will only create letters for the checked names.
Can I use mail merge to send emails instead of printing letters?
Yes. Set up your template and merge fields the same way, but in the Finish & Merge menu, choose Send Email Messages. Your data source must include an email address column. Word will open your default email program and create one message for each person with the personalized information filled in.
What happens if my merge field does not show the data I expect?
Check that the column header in your spreadsheet matches the merge field name exactly, including capitalization and spacing. Also make sure you saved the spreadsheet before you opened it in Word. If you edited the Excel file after connecting it to Word, you may need to click Edit Recipient List and refresh the connection to see the updated data.
Can I edit individual letters after the merge is done?
Yes. When you finish the merge and choose Edit Individual Documents, Word creates a new file with all the merged letters. You can then edit any letter you want — fix a typo, adjust formatting, or add a handwritten note before printing. The original template and data source remain unchanged.