What mail merge does and when you need it

Mail merge takes a list of names, addresses, or other information from Excel and automatically fills that data into a Word document template. Instead of typing each person's details into separate letters, you create one template with placeholders, and Word pulls the real information from your spreadsheet and generates a personalized copy for each row.

You use mail merge when you need to send the same document to many people with their individual details filled in — form letters to clients, mailing labels, envelopes, email messages, or personalized certificates. The process saves hours of manual typing and reduces mistakes.

Key Takeaways

  • Your Excel file must have column headers in the first row, with each person's information in the rows below, before you start the merge.
  • In Word, you create a template document, then use the Mailings tab to connect it to your Excel file and insert merge fields where the data should go.
  • Word generates a separate copy of the document for each row in your spreadsheet, with the person's actual details filled in.
  • You can preview the merged results before printing or saving, so you can catch problems with formatting or data before you finish.

Setting up your Excel spreadsheet correctly

Mail merge reads data from Excel by looking at column headers — the labels in the first row. Each column should contain one type of information: FirstName, LastName, Address, City, State, ZipCode, and so on. Use clear, simple header names without spaces or special characters (FirstName works; First Name does not).

Put each person's information in a separate row below the headers. If your spreadsheet already has data with headers, you are ready to go. If you are building a new list, type the headers first, then add one person per row. Save the file before you open Word — mail merge works best when the Excel file is closed or at least saved to disk.

Check your data for blank cells, extra spaces, or typos before you merge. Mail merge will copy whatever is in the spreadsheet exactly as it appears, so "John" and "john" will merge differently, and a blank cell will leave a gap in your document.

Creating your Word template with merge fields

Open Word and create a new document or open an existing one you want to use as a template. Type the body of your letter or document as you normally would. Wherever you want Excel data to appear, you will insert a merge field — a placeholder that tells Word where to pull information from your spreadsheet.

To insert a merge field, go to the Mailings tab at the top of Word. Click Select Recipients, then choose Use an Existing List. Navigate to your Excel file and open it. Word will read the column headers from your spreadsheet.

Now click in your document where you want the first piece of data to appear. Go back to the Mailings tab and click Insert Merge Field. A dropdown menu shows all the column headers from your Excel file. Click the one you want — for example, FirstName. Word inserts a field that looks like <<FirstName>> into your document. Repeat this for each piece of data you need: address, city, date, or any other field from your spreadsheet.

Previewing and finishing the merge

Before you merge all the documents, preview what the result will look like. In the Mailings tab, click Preview Results. Word shows you the first person's data filled into your template. Use the arrow buttons to scroll through a few examples and check that the formatting looks right and the data is in the correct places.

If something is wrong — a merge field is in the wrong spot, or the spacing looks off — click Preview Results again to turn off the preview, fix the template, and then preview again. Once you are satisfied, you are ready to finish the merge.

Click Finish & Merge in the Mailings tab. You have three options: Edit Individual Documents (opens all merged documents in a new Word file so you can review or edit them before printing), Print Documents (sends them straight to your printer), or Send Email Messages (if you are merging into email bodies). Choose the option that fits your workflow.

Saving merged documents and troubleshooting common problems

If you choose Edit Individual Documents, Word creates a new document with all the merged letters. You can then save this file, print it, or make changes before you do. If you choose Print Documents, the merge prints directly without saving individual files — useful if you only need paper copies.

Common problems include merge fields not filling in with data (check that your Excel file is saved and the column headers match exactly what you typed in the merge field), extra spaces appearing in the document (remove spaces before or after merge fields in your template), or the wrong data appearing in the wrong place (verify that your Excel columns are in the order you expect).

If the merge produces blank pages or strange formatting, open your template again, delete all the merge fields, and re-insert them one at a time, checking the preview after each one. This helps you find which field is causing the problem.

Using mail merge for different document types

Mail merge works the same way for letters, labels, and envelopes — you create a template and insert merge fields. For mailing labels, start with a blank document, go to Mailings, click Start Mail Merge, and choose Labels. Word prompts you to select a label size (Avery 5160 is the standard for address labels). Then insert your merge fields for address information, and Word automatically formats them across the label sheet.

For envelopes, choose Envelopes from the Start Mail Merge menu instead of Labels. The process is the same: insert merge fields for the recipient's address and your return address, preview, and finish. For email messages, create your template in Word, then use Send Email Messages at the finish step — Word opens your email program and sends a personalized message to each address in your EmailAddress column.

Frequently Asked Questions

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

Yes. Download your Google Sheet as an Excel file (.xlsx), save it to your computer, and then use that file in the mail merge process. You can also save a Google Sheet as a CSV file and use that instead — Word reads both formats the same way.

What if my Excel file has more columns than I need for the merge?

Mail merge only uses the columns you insert as merge fields in your template. Extra columns in your spreadsheet do not affect the merge — they are simply ignored. You can keep all your data in one file and use only the columns that matter for each template.

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

Yes. Choose Edit Individual Documents at the finish step, and Word opens a new document with all the merged copies. You can then edit any of them, delete pages you do not need, or make other changes before you save or print.

What happens if my Excel file has a blank cell?

Mail merge leaves that space blank in the document. If you have a blank address field, for example, the address line will be empty. Review your Excel data for missing information before you merge, or use the preview feature to catch blanks before you finish.

Can I use mail merge to send emails directly from Word?

Yes, but Word sends the emails through your default email program (Outlook, Gmail in a browser, or another client). Create your email template in Word with merge fields, choose Send Email Messages at the finish step, and Word opens your email program with personalized messages ready to send. You must have an email account set up on your computer for this to work.