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 them into a Word document template. Instead of typing each person's details by hand into separate letters, you create one template with placeholder fields, and Word pulls the data from your spreadsheet to generate dozens or hundreds of personalized documents in minutes.

The most common use is sending personalized letters — a school might mail merge student names and addresses into a letter template to notify families about an event. A business might merge customer names into an invoice template. A nonprofit might personalize thank-you letters to donors. Any situation where you have a list of people and want to create individual documents with their specific information is a mail merge job.

Without mail merge, you would copy and paste each person's name and address into a new document, save it with a unique filename, and repeat for every person on your list. Mail merge does all of that automatically in one operation.

Key Takeaways

  • Your data lives in an Excel spreadsheet with column headers (Name, Address, Email) and one row per person, while your template is a Word document with placeholder fields like <<Name>> and <<Address>>.
  • You start the merge in Word by going to the Mailings tab, selecting Start Mail Merge, and choosing your data source — the Excel file.
  • Word inserts merge fields into your template using the Insert Merge Field button, which pulls data from the matching column headers in your spreadsheet.
  • You preview the merged results before finalizing to catch errors, then finish the merge to create individual documents or print them directly.
  • Common mistakes include mismatched column headers between Excel and Word, blank rows in your spreadsheet, and forgetting to save the Excel file before starting the merge.

Setting up your Excel spreadsheet correctly

Your Excel file is the data source — it holds all the information that will fill into your Word template. The structure matters. The first row must contain column headers that describe what each column contains: Name, Address, City, State, ZIP, Email, or whatever fields you need. Each row below the headers represents one person or record.

Do not leave blank rows in the middle of your data. If you have 50 people, rows 2 through 51 should all contain data with no empty rows between them. Blank rows cause Word to generate blank documents during the merge. If you need to remove someone from the list, delete the entire row rather than just clearing the cells.

Keep your data clean: no extra spaces before or after names, consistent spelling and capitalization, and no special characters that might confuse Word. If your spreadsheet has a column you do not need for the merge, you can leave it there — Word will only use the columns you actually insert into the template. Save the Excel file before you open Word, and keep it saved in a location you can find easily.

Creating your Word template with merge fields

Open Word and create the document you want to send to each person. Write the body of your letter, invoice, label, or whatever document type you need. Wherever you want information from your Excel spreadsheet to appear, you will insert a merge field — a placeholder that tells Word where to pull data from.

To insert a merge field, click the Mailings tab at the top of Word. Click Insert Merge Field and a dropdown menu appears showing all the column headers from your Excel file. Click the header that matches what you want to insert — for example, click "Name" to insert the <<Name>> field. Word inserts the field in your document surrounded by double angle brackets.

Type your template text around the merge fields exactly as you want it to appear in the final documents. For example: "Dear <<Name>>," or "Invoice for <<Company>>, <<Address>>, <<City>>, <<State>> <<ZIP>>." The merge fields will be replaced with actual data from your spreadsheet when you run the merge. Save this template with a clear name like "Letter_Template" or "Invoice_Template" so you know what it is.

Running the mail merge and previewing results

With your template open in Word, go to the Mailings tab and click Start Mail Merge. Choose the document type you are creating — usually "Letters" for a standard mail merge. Then click Select Recipients and choose Use an Existing List. Navigate to your Excel file and open it. Word asks which sheet contains your data — if you only have one sheet, it selects it automatically.

Before you create all the documents, preview what they will look like. Click Preview Results in the Mailings tab. Word displays your template with actual data from the first row of your spreadsheet filled in. Use the arrow buttons to scroll through a few records and verify that the names, addresses, and other information are appearing in the right places. If something looks wrong — a field is blank, or data is in the wrong position — stop here and fix the problem before proceeding.

Common preview problems include a merge field showing the column header name instead of actual data (which means the header in Excel does not exactly match the field name in Word), or blank fields (which means that column is empty in your spreadsheet for that row). Fix these issues in Excel or by re-inserting the correct merge field in Word, then preview again.

Finishing the merge and saving your documents

Once the preview looks correct, you have two options for finishing the merge. Click Finish & Merge in the Mailings tab. Choose Edit Individual Documents if you want to review or make changes to each document before saving — Word creates a new document containing all the merged results, one after another, and you can edit any of them. Choose Print Documents if you want to print all the merged documents directly to your printer without saving them as files first.

If you chose Edit Individual Documents, Word creates a new document called something like "Letters1" containing all your merged letters. You can scroll through, make any final adjustments, and then save this file. If you want to save each person's document as a separate file instead of one large document, you will need to manually split them or use a more advanced method — the standard mail merge creates one combined file.

If you chose Print Documents, Word sends all the merged documents directly to your printer. This is useful when you just need to print and mail physical letters and do not need to keep digital copies. Make sure your printer is on and ready before you select this option.

Troubleshooting common mail merge problems

If merge fields show the field name (like <<Name>>) instead of actual data, the column header in your Excel file does not match exactly. Check for extra spaces, different capitalization, or typos. The header in Excel must match the merge field name in Word character for character. Fix the header in Excel, save the file, and try the merge again.

If some records produce blank documents or documents with missing information, check your Excel spreadsheet for blank rows or blank cells in specific columns. Delete any blank rows between data rows. If a particular column is empty for some people, that is fine — the field will just be blank in those documents, which may be what you want.

If Word cannot find your Excel file, make sure the file is saved and closed before you start the merge. Word needs to access the file, and some versions have trouble if the file is open in Excel at the same time. Save and close Excel, then proceed with the merge in Word.

Frequently Asked Questions

Can I mail merge from a Google Sheet instead of Excel?

Word can merge from Google Sheets, but the process is slightly different. read your Google Sheet as an Excel file (.xlsx), then use that file as your data source in Word. Alternatively, some versions of Word allow you to connect directly to a Google Sheet, but downloading and saving locally is more reliable.

What if I want to save each merged document as a separate file with a unique name?

The standard mail merge creates one combined document. To save individual files, you can use a macro or third-party add-in, but these require more technical setup. For most users, the simplest approach is to finish the merge into one document, then manually save sections as separate files, or use an online mail merge tool designed for this purpose.

Can I merge into envelopes or labels instead of letters?

Yes. When you click Start Mail Merge, choose "Envelopes" or "Labels" instead of "Letters." Word will guide you through setting up the envelope or label format, and the merge process works the same way — you insert merge fields for the address information and run the merge.

What happens if my Excel file has more columns than I actually use in the merge?

Extra columns do not cause problems. Word only uses the columns you insert as merge fields in your template. You can have columns for phone number, email, and notes in Excel but only merge the name and address into your letter — the other data straightforward stays in the spreadsheet and does not appear in the documents.

Can I use mail merge to send emails instead of creating documents?

Word's mail merge is designed for documents, envelopes, and labels, not email. To send personalized emails from a list, you would use your email client's mail merge feature (Outlook has one built in) or a dedicated email service. Word mail merge creates documents you then print or save, not emails you send.