What Mail Merge Does and Why You'd Use It

Mail merge takes a list of names, addresses, or other information stored in Excel and automatically fills that data into a template document — usually in Word. Instead of typing the same letter 50 times with different names, you create one template and let the merge do the repetitive work. The result is a set of personalized documents, one for each row in your Excel sheet.

The most common use is sending personalized letters to a mailing list: a template letter that says "Dear [Name]," pulls the actual name from your spreadsheet for each copy. You can also merge data into labels, envelopes, or email messages. The process saves time when you have more than a handful of documents to create, and it eliminates the typos that come from manual copying.

Key Takeaways

  • Mail merge requires two files: an Excel spreadsheet with your data (names, addresses, etc.) and a Word document template with merge fields that pull from that data.
  • Your Excel data must have column headers in the first row — these headers become the merge field names that Word recognizes.
  • In Word, you insert merge fields by going to the Mailings tab, selecting your Excel file as the data source, and clicking where you want each field to appear.
  • Before finalizing, use the Preview Results button in Word to check that the merged data looks correct in a few sample documents.
  • The final step is Finish & Merge, which creates individual documents or prints them directly without saving separate files.

Setting Up Your Excel Data the Right Way

Mail merge works only if your Excel spreadsheet is organized correctly. The first row must contain column headers — these are the labels that Word will recognize as merge field names. If your first row contains actual data instead of headers, the merge will treat that row as a field name and skip it in your final documents.

Each column should hold one type of information: one column for first names, one for last names, one for addresses, one for cities, and so on. Do not combine "John Smith" in a single cell if you want to address the letter to "John" alone — split them into separate columns. Keep the data clean: remove extra spaces at the beginning or end of cells, and do not leave blank rows in the middle of your list. A blank row will create a blank merged document, which wastes paper and time.

Save your Excel file before you open Word. You will need to browse to this file from Word, so know where you saved it and what you named it. A simple name like "MailList.xlsx" is easier to find than "Final_FINAL_v3_updated.xlsx".

Creating Your Template in Word

Open a new Word document and write the text you want to appear in every merged document. This is your template. Type the letter, label, or envelope text exactly as you want it, except where you need data from Excel to fill in. For a letter, you might write:

Dear [First Name], Thank you for your recent purchase. We are writing to confirm your order for [Product Name] to be shipped to [Address].

The bracketed parts are placeholders — you will replace them with actual merge fields in the next step. Do not type the brackets yourself; Word will insert the real merge fields for you. Format your template the way you want the final documents to look: set margins, choose fonts, add a logo or letterhead. All of that formatting will carry through to every merged document.

Save this template file in Word format (.docx) before you begin the merge. Give it a clear name like "LetterTemplate.docx" so you can find it again if you need to edit it later.

Inserting Merge Fields from Your Excel Data

With your template open in Word, click the Mailings tab at the top of the ribbon. Click Select Recipients, then choose Use an Existing List. Browse to your Excel file and open it. Word will read the column headers from your spreadsheet and recognize them as available merge fields.

Now click in your template where you want the first piece of data to appear — for example, right after "Dear " in your greeting. Click Insert Merge Field and select the field name from the dropdown list. If your Excel column is labeled "FirstName", click that option. Word will insert the field as <<FirstName>> in your template. Repeat this for every piece of data you want to pull in: address, city, product name, or whatever your spreadsheet contains.

The merge fields appear in double angle brackets in your template, but they will show as actual data when you preview or finalize the merge. Do not delete or retype these fields — they are the connection between your template and your Excel data.

Checking Your Work Before You Merge

Before you create all the final documents, preview what a few of them will actually look like. Click Preview Results in the Mailings tab. Word will show you the first merged document with real data from your Excel file filling in the merge fields. Use the arrow buttons to flip through a few more examples — check the second, the middle one, and the last to make sure the data is correct and the formatting looks right.

Look for common problems: names that are misspelled in your Excel file, addresses that are incomplete, or merge fields that did not insert correctly and are showing as blank. If you spot an error in the data itself, click Edit Recipient List to go back to your Excel file and fix it. If a merge field is missing or in the wrong place, click Preview Results again to turn off the preview, then edit your template and add the field where it belongs.

Once the preview looks correct, you are ready to finish the merge.

Completing the Merge and Saving Your Documents

Click Finish & Merge in the Mailings tab. You have three options: Edit Individual Documents, Print Documents, or Send Email Messages. Choose based on what you want to do next.

Edit Individual Documents creates a new Word file containing all your merged documents stacked together — one after another, each on its own page. You can then edit any individual document if you need to make changes to a specific letter. This option gives you the most control but creates a large file if you have hundreds of documents.

Print Documents sends all the merged documents directly to your printer without saving them as files. Use this if you are printing letters or labels and do not need to keep digital copies. Send Email Messages works only if one of your Excel columns contains email addresses; it opens your email program and creates individual messages with the merge data filled in.

After you finish the merge, your original template remains unchanged in Word. You can use it again with a different Excel file, or edit it and run the merge again with the same data.

Troubleshooting Common Merge Problems

If a merge field shows as blank in the preview, the most common cause is a mismatch between the field name in your template and the column header in Excel. Check that the spelling and capitalization match exactly. "FirstName" in your template must match a column header labeled exactly "FirstName" in Excel — "First Name" with a space will not work.

If your Excel file will not open when you click Select Recipients, make sure the file is not open in another program at the same time. Close Excel completely, then try again from Word. If you moved or renamed your Excel file after you started the merge, Word may lose the connection; click Edit Recipient List and browse to the file in its new location.

If the merged documents look correct but have extra blank pages, check your Excel file for blank rows at the end of your data. Delete any empty rows, save the file, and run the merge again. If you are merging to email and the messages are not sending, make sure your email program (Outlook, Gmail, etc.) is set up and logged in on your computer.

Frequently Asked Questions

Can I merge data from multiple Excel sheets at once?

No. Mail merge works with one sheet at a time. If your data is split across multiple sheets, copy all the data into a single sheet first, then run the merge. Make sure the column headers are the same across all the data you combine.

What if I want to merge only some rows from my Excel file, not all of them?

Click Edit Recipient List in the Mailings tab. You can uncheck the box next to any row you do not want to merge. Only the checked rows will be included in the final documents. This is useful if you want to send letters only to certain cities or only to customers who made a purchase above a certain amount.

Can I use mail merge to create labels or envelopes instead of letters?

Yes. In Word, go to Mailings and click Start Mail Merge, then choose Labels or Envelopes instead of Letters. Word will set up the template in the correct format for your label or envelope size. Insert merge fields the same way you would for a letter.

What happens if I edit my Excel file after I start the merge?

Word uses a snapshot of your Excel file at the moment you select it as the data source. If you edit the Excel file later, those changes will not show up in Word unless you click Edit Recipient List and refresh the connection. It is safest to finalize all your data in Excel before you start building your template in Word.

Can I merge data into an email message instead of a Word document?

Yes, but only if one of your Excel columns contains email addresses. In Word, go to Mailings, click Start Mail Merge, and choose Email Messages. Insert your merge fields into the email body, then click Finish & Merge and select Send Email Messages. Word will open your email program and create individual messages for each row in your data.