Mail merge pulls data from an Excel spreadsheet into a Word template to create personalized letters, labels, or envelopes

A mail merge takes a list of names, addresses, or other information stored in Excel and automatically fills those details into a Word document template. Instead of typing each person's name and address into separate letters, you set up one template in Word, point it to your Excel file, and Word generates a customized copy for each row in your spreadsheet. The process involves three steps: preparing your Excel data, creating a template in Word, and running the merge.

Mail merge works best when your Excel data is organized in columns — one column for first names, one for last names, one for addresses, and so on. Word reads the column headers and uses them as placeholders in your template. When you run the merge, Word replaces each placeholder with the corresponding data from each row.

Key Takeaways

  • Your Excel file must have column headers in the first row, with each piece of information (name, address, email) in its own column.
  • In Word, you insert merge fields that match your Excel column headers, and Word replaces them with actual data during the merge.
  • You can preview the merged results before printing or saving, so you can catch mistakes in your data or template.
  • Mail merge works with letters, labels, envelopes, and email messages — the template format determines the output.

Prepare your Excel spreadsheet with proper column headers

Open your Excel file and make sure the first row contains headers that describe each column. For example, if you are sending letters to customers, your first row might have: FirstName, LastName, Address, City, State, ZipCode, Email. Each subsequent row holds one person's information. Do not leave blank rows in the middle of your data — Excel reads from the first data row down to the last row with content, and blank rows will cause the merge to stop or create empty documents.

Save your Excel file before you move to Word. Use a simple file format like .xlsx (the standard Excel format) rather than .csv or .txt, because Word recognizes .xlsx files more reliably. Close the file completely — Word needs exclusive access to it during the merge, and leaving it open in Excel can cause errors.

Create a template in Word with merge field placeholders

Open a new Word document and write the template text. For a letter, this might be a standard business letter format with your company name at the top, the date, and the body of the letter. Wherever you want Excel data to appear, you will insert a merge field instead of typing the actual name or address.

To insert a merge field, go to the Mailings tab in Word's ribbon menu. Click Select Recipients and choose Use an Existing List. Navigate to your Excel file and open it. Word will ask which sheet you want to use — if your data is on Sheet1, select that. Once you select the file, Word loads the column headers from your Excel spreadsheet.

Now click in your template where you want the first piece of data to appear. Go to Mailings and click Insert Merge Field. A dropdown menu shows all the column headers from your Excel file. Click the header you want — for example, FirstName. Word inserts a placeholder that looks like <<FirstName>>. Repeat this for each piece of data you need. Your template might look like this:

Dear <<FirstName>> <<LastName>>, We are writing to confirm your appointment on <<AppointmentDate>> at <<Location>>.

Preview the merge results before finalizing

Before you create all the merged documents, preview what the output will look like. In the Mailings tab, click Preview Results. Word replaces the merge field placeholders with actual data from your Excel file and shows you the first record. Use the arrow buttons to scroll through a few records and check that the data appears in the right places and looks correct.

If you notice a problem — for example, a name is misspelled in Excel, or a merge field is in the wrong spot in your template — go back and fix it. If the problem is in Excel, close Word, fix the data in Excel, save the file, and reopen your Word template. If the problem is in the template, edit the template directly and preview again.

Complete the merge and save or print the results

Once the preview looks correct, you are ready to finish the merge. In the Mailings tab, click Finish & Merge. You have three options: Edit Individual Documents, Print Documents, or Send Email Messages.

Choose Edit Individual Documents if you want to review or make changes to each merged document before printing. Word creates a new document with all the merged letters, one after another, and you can edit any of them. Choose Print Documents if you want to print directly to your printer without reviewing each one first. Choose Send Email Messages if your template is an email and you have an email address column in Excel — Word will send each person a customized email.

If you chose Edit Individual Documents, Word opens a new document called something like "Letters1" that contains all your merged results. You can save this file for your records, or you can print from it. If you chose Print Documents, Word sends the pages directly to your printer and closes without saving a file.

Troubleshoot common merge problems

If merge fields show as <<FieldName>> instead of actual data, the merge did not run. Make sure you clicked Finish & Merge and selected an option. If the data looks wrong or is missing, check your Excel file for blank cells, extra spaces, or typos in the column headers. The header names in Excel must match exactly what you typed in the merge field — if Excel says "FirstName" but you typed "First Name" in Word, the merge will fail.

If Word says it cannot find your Excel file, make sure the file is saved and closed, and that you are using the correct file path. If you moved the Excel file to a different folder after setting up the merge, Word will not find it — you will need to select the file again using Select Recipients > Use an Existing List.

Use mail merge for different document types

Mail merge is not limited to letters. You can use the same process to create mailing labels, envelopes, or email messages. For labels, start with a blank Word document, go to Mailings > Labels, and choose your label size. Then insert merge fields just as you would for a letter. For envelopes, go to Mailings > Envelopes and set up the return address and recipient address fields.

For email messages, your Word template becomes the email body. Make sure your Excel file has an email address column. When you run the merge and choose Send Email Messages, Word will send each person a customized email using your default email program. The subject line and message body come from your template, and the recipient address comes from the email column in Excel.

Frequently Asked Questions

Can I merge data from multiple sheets in one Excel file?

No, mail merge pulls from one sheet at a time. If your data is split across multiple sheets, copy all the data into a single sheet before you start the merge. Make sure the column headers are identical across all the data you combine.

What if my Excel file has special characters or accented letters?

Mail merge handles special characters and accented letters without problems, as long as your Excel file is saved in .xlsx format. If you see garbled text in the merged output, the issue is usually with the Excel file encoding — save it again as .xlsx and try the merge again.

Can I edit individual merged documents after the merge is complete?

Yes. When you choose Edit Individual Documents during the merge, Word creates a new document with all the results, and you can edit any letter, label, or envelope before printing. Once you save this document, the merge fields are converted to regular text and cannot be updated by re-running the merge.

How do I update the merge if I add new rows to my Excel file?

Close your Word template, update your Excel file with the new data, and save it. Reopen the Word template and run the merge again. Word will read all the rows in your updated Excel file, including the new ones.

What is the maximum number of records I can merge?

Word can handle thousands of records in a single merge, but the process slows down with very large files. If you have more than 10,000 rows, consider splitting your Excel data into smaller files and running separate merges for each batch.