What a mail merge does and why you'd use it

A mail merge takes a list of names, addresses, or other information from Excel and automatically fills them into a template — usually a letter or label — so you don't have to type each one by hand. Instead of writing "Dear John" fifty times, you write it once with a placeholder, and the mail merge software fills in each person's actual name.

The most common reason to do this is sending personalized letters to many people at once. You might also use it to create mailing labels, envelopes, or email messages. The process involves three parts: your Excel data, a template document (usually in Word), and the mail merge tool that connects them.

Key Takeaways

  • Mail merge requires two files: an Excel spreadsheet with your data and a Word document as your template.
  • Your Excel column headers must match exactly what you want to insert — if the column says "FirstName", you'll use that exact text in your Word template.
  • Word's mail merge tool is found under the Mailings tab, and you start by selecting your Excel file as the data source.
  • You insert merge fields (placeholders) into your Word template, then preview the results before printing or saving.
  • Common mistakes include mismatched column names, forgetting to save Excel before starting, and not previewing before printing.

Setting up your Excel file correctly

Before you open Word, your Excel spreadsheet needs to be organized in a specific way. The first row must contain headers — these are the labels for each column. If you want to merge someone's first name, put "FirstName" in the first cell of the first column. If you need their address, put "Address" in another column header. Every row below the headers is one person's information.

Keep your headers simple and without spaces if possible — use "FirstName" instead of "First Name", and "LastName" instead of "Last Name". This prevents confusion later. Make sure there are no blank rows in the middle of your data, and save the file before you move to Word. The file can stay open in Excel while you work in Word, but it must be saved to disk.

Check that all the information is spelled correctly and complete. If you're missing someone's zip code, leave that cell blank rather than putting a placeholder like "N/A" — the merge will handle blanks more cleanly than text you didn't mean to print.

Creating your Word template with merge fields

Open a new Word document and write the letter, label, or envelope exactly as you want it to appear — except where you want information from Excel to go. For example, type "Dear " and then stop. Don't type the person's name yet.

Go to the Mailings tab at the top of Word. Click "Select Recipients" and choose "Use an Existing List". A file browser will open — find and select your Excel file. Word will ask which sheet to use (usually "Sheet1") and will read your headers automatically.

Now go back to your template and place your cursor where you want the first name to appear. Click "Insert Merge Field" in the Mailings tab. A list of your column headers will appear — click "FirstName" (or whatever your header is called). Word will insert it as a gray box with the text in angle brackets, like <<FirstName>>. This is a merge field, and it tells Word to replace this box with the actual name when you run the merge.

Continue typing and inserting merge fields until your template is complete. If you need an address block, you can click "Address Block" instead of "Insert Merge Field" — this is a shortcut that combines multiple fields (street, city, state, zip) into a standard format.

Previewing your merge before printing

Before you print or save anything, preview what the merge will actually look like. In the Mailings tab, click "Preview Results". The gray merge fields will disappear and be replaced with real data from your first row in Excel. You'll see "Dear John" instead of "Dear <<FirstName>>".

Use the arrow buttons next to "Preview Results" to flip through a few rows and make sure the names, addresses, and other information are appearing correctly. If something looks wrong — like a name appearing in the wrong place or a field showing up blank — go back and check your Excel headers and your merge fields in Word. The most common problem is a typo in the merge field name that doesn't match your Excel header exactly.

If the preview looks right, you're ready to finish the merge. Click "Finish & Merge" in the Mailings tab. You have three options: print directly to your printer, send to email, or create a new document with all the merged letters combined.

Completing the merge and saving your results

If you choose "Edit Individual Documents", Word creates a new document with one letter for each row in your Excel file. You can then print this document, save it, or edit individual letters if needed. This is the safest option if you want to review everything before printing.

If you choose "Print Documents", Word sends everything directly to your printer. Use this only if you've previewed thoroughly and you're confident the merge is correct.

If you choose "Send Email Messages", Word will create an email for each person (if your Excel file includes an email column). This is less common but works the same way.

After the merge is complete, save your Word template for next time. You can reuse it with a different Excel file, or update the same Excel file and run the merge again without rebuilding the template.

Troubleshooting common problems

If merge fields aren't appearing in your preview, check that your Excel column headers match exactly what you typed in the merge field. "FirstName" and "firstname" are different — Word is case-sensitive. Go back to your Excel file, note the exact spelling and capitalization of each header, and fix any merge fields in Word that don't match.

If some rows are missing from the preview, check your Excel file for blank rows in the middle of your data. Delete any empty rows between your headers and your last entry. Also make sure you selected the correct sheet if your Excel file has multiple sheets.

If the merge looks fine but prints incorrectly, the problem is usually with your printer settings, not the merge itself. Try printing to a PDF first to see if the problem is in Word or in the printer.

If you need to change the data, close Word without saving the merged document, update your Excel file, and run the merge again. Your template will still be there and will pull the new data automatically.

Frequently Asked Questions

Can I do a mail merge with Google Sheets instead of Excel?

Google Sheets works, but the process is different. You'll need to use Google Docs as your template and install a mail merge extension from the Google Workspace Marketplace. The steps are similar — headers in the first row, merge fields in your template — but the tools are different. Microsoft Word with Excel is the most straightforward method.

What if I only want to merge to some of the rows, not all of them?

In Word's Mailings tab, click "Edit Recipient List" before you finish the merge. A dialog will open showing all your rows. Uncheck the rows you don't want to include. Only the checked rows will be merged.

Can I merge to envelopes or labels instead of letters?

Yes. Instead of writing a letter, start a new Word document and go to Mailings > Envelopes or Labels. Select your Excel file as the data source, and Word will guide you through setting up the template for envelopes or labels. The merge fields work the same way.

Do I need to keep my Excel file open while I'm doing the merge?

No. Excel can be closed. Word just needs to know where the file is saved on your computer. However, if you make changes to the Excel file after you've started the merge in Word, you'll need to refresh the data source in Word for those changes to show up.

What happens if my Excel data has special characters or accents?

They should merge correctly as long as your Excel file is saved in a standard format like .xlsx. If you see strange characters in the preview, check that your Excel file is using UTF-8 encoding. Most modern Excel files do this automatically.