What a mail merge does and why you need it

A mail merge takes a list of names, addresses, or email information from Excel and automatically fills them into a Word document template. Instead of typing each person's name and address by hand, you create one document with blanks, point Word to your Excel list, and Word fills in the blanks for every person on the list at once.

This saves hours if you are sending letters, envelopes, or emails to dozens or hundreds of people. A school might use it to send acceptance letters to new students. A business might use it to send invoices with each customer's account number already filled in. The document stays the same; only the personal details change.

You need two things to start: an Excel spreadsheet with your data organized in columns, and a Word document set up as your template. The process takes about 15 minutes to learn and works the same way every time.

Key Takeaways

  • Your Excel file must have column headers in the first row (Name, Address, Email) and one person per row below that.
  • In Word, you insert merge fields where you want the data to appear, using the Mailings tab on the ribbon.
  • Word matches column names from Excel to merge fields in your template automatically.
  • You can preview how each letter will look before printing or sending, and save individual letters as separate files if needed.

Set up your Excel spreadsheet the right way

Open Excel and create a new spreadsheet. In the first row, type the column headers that describe your data. Common headers are FirstName, LastName, Address, City, State, ZipCode, and Email. Use one word for each header with no spaces, or use headers like "First Name" with spaces — either works, but be consistent.

Starting in row 2, enter one person per row. Put their first name in the FirstName column, their last name in the LastName column, and so on. Each column should contain only one type of information. If you have 50 people to mail to, you will have 50 rows of data plus the header row.

Save your Excel file with a clear name like "MailMergeList.xlsx" in a folder you can find easily. Do not close it yet — you will need it open or at least saved and ready when you switch to Word.

Create your Word template with merge fields

Open Word and create a new blank document. Type out the letter or document you want to send. Where you want a person's name to appear, type the word in brackets for now, like [FirstName] or [LastName]. Do the same for address, email, or any other field from your Excel spreadsheet.

For example, a letter might look like this:

Dear [FirstName] [LastName], We are writing to confirm your order. Your address on file is: [Address] [City], [State] [ZipCode] If this is incorrect, please contact us at support@example.com.

Once your template is written and looks the way you want it, save this file with a name like "MailMergeTemplate.docx". Do not close it — you will use it next.

Connect Word to your Excel file and insert merge fields

With your template open in Word, click the Mailings tab on the ribbon at the top of the screen. If you do not see a Mailings tab, you are using an older version of Word; look for Tools in the menu bar instead.

Click Start Mail Merge and choose Letters (or Email Messages if you are sending emails). Next, click Select Recipients and choose Use an Existing List. Browse to your Excel file and open it. Word will ask which sheet contains your data — if you only have one sheet, it will select it automatically.

Now go back to your template and delete the bracketed placeholders you typed earlier. Click where [FirstName] was, then click Insert Merge Field on the Mailings tab. A dropdown menu appears showing all the column headers from your Excel file. Click FirstName. Word inserts a merge field that looks like «FirstName» in gray.

Repeat this for every placeholder in your document. Click where [LastName] was and insert the LastName merge field. Click where [Address] was and insert the Address merge field. Continue until every piece of data from your Excel file is replaced with a merge field from Word.

Preview your merged documents before printing or sending

Before you print or send anything, check that the merge will work correctly. Click Preview Results on the Mailings tab. Word shows you what the first letter will look like with the first person's data filled in. Use the arrow buttons to flip through and see how the second, third, and fourth letters look.

Look for problems like names appearing in the wrong place, missing data, or extra spaces. If something is wrong, click Preview Results again to turn off the preview, fix the template, and then turn the preview back on to check again.

Common mistakes are forgetting to add a space between merge fields (so "John" and "Smith" appear as "JohnSmith") or inserting the wrong merge field in the wrong place. These are easy to spot in the preview and easy to fix.

Finish the merge and save or print your letters

Once the preview looks correct, click Finish & Merge on the Mailings tab. You have three options: Print Documents sends everything directly to your printer, Send Email Messages sends merged emails if you set up an email merge field, and Edit Individual Documents creates a new Word file with all the merged letters so you can review or edit them before printing.

For most people, Edit Individual Documents is the safest choice. Word creates a new document with all your letters, one after another, separated by page breaks. You can scroll through, make any last-minute changes, and then print from there. This also gives you a copy to keep.

If you choose Print Documents, a dialog box appears asking which letters to print. You can print all of them or just a range, like letters 1 through 10. Click OK and your printer starts printing.

Troubleshooting common problems

If Word cannot find your Excel file, make sure the file is saved and closed. Some versions of Word have trouble reading Excel files that are still open. Close Excel completely, then try selecting the file again in Word.

If a merge field shows the column name instead of the actual data (like it prints «FirstName» instead of "John"), the merge did not connect properly. Go back to the Mailings tab, click Select Recipients, and choose your Excel file again. Then delete the broken merge field and insert a new one.

If some rows in your Excel file are not merging, check that every row has data in the columns you are using. If a row is completely empty or has only a name with no address, Word may skip it or create a blank letter. Delete empty rows from your Excel file and try again.

If you are sending emails and they are not going through, make sure you set up an Email merge field (not a regular merge field) and that Outlook is installed and set up on your computer. Email merges require Outlook to work.

Frequently Asked Questions

Can I use a mail merge with a Google Sheet instead of Excel?

Word on Windows can read Google Sheets if you download them as .xlsx files first. Open your Google Sheet, click File, then Download, and choose Microsoft Excel. Save the file and use it in Word the same way you would use an Excel file. Word on Mac has more limited support for Google Sheets, so downloading is the most reliable method.

What if I need to send emails instead of printing letters?

Set up your template the same way, but include an Email merge field where you want the recipient's email address to go. On the Mailings tab, click Finish & Merge and choose Send Email Messages. Word will ask which merge field contains the email addresses. Select the Email column from your Excel file and Word sends one email to each person with their personalized message.

Can I merge data into envelopes?

Yes. On the Mailings tab, click Start Mail Merge and choose Envelopes instead of Letters. Word opens a dialog to set up your envelope size and layout. Insert merge fields for the address the same way you would in a letter, then finish the merge. You can print envelopes directly or edit them first.

What happens if I make a mistake in my Excel data after I start the merge?

Close your Word document without saving the merged results. Go back to Excel, fix the data, save the file, and start the merge over in Word. If you already saved the merged document with the wrong data, you can delete it and create a new one with the corrected Excel file.

Can I use mail merge to fill in forms?

Yes, if the form is a Word document. Create your template by opening the form, inserting merge fields where you want data to appear, and then connect it to your Excel file the same way. This works well for applications, invoices, or any form that repeats with different data for each person.