What Mail Merge Does and When to Use It

Mail merge is a Word feature that takes a list of names, addresses, or email details from a spreadsheet and automatically fills them into a template letter or email. Instead of typing each recipient's name and address by hand, you create one document with placeholder fields, and Word inserts the correct information for each person.

Mail merge saves time when you need to send the same message to many people but want each copy to feel personal. Common uses include sending letters to multiple addresses, creating envelopes with different names, or generating personalized emails. The process has three main parts: preparing your data in a list, setting up your template in Word, and running the merge.

Key Takeaways

  • Mail merge requires two files: a data source (usually an Excel spreadsheet with names and addresses) and a Word template with merge fields where the data will go.
  • Your data list must have column headers in the first row — Word uses these headers to match information to the right merge fields in your template.
  • You insert merge fields into your Word template by going to the Mailings tab and selecting the fields you want to pull from your data source.
  • Before sending anything, use Preview Results to check that the merged data looks correct and that names and addresses appear in the right places.
  • You can merge to a new document to review everything before printing or sending, or merge directly to email if your data includes email addresses.

Prepare Your Data in a Spreadsheet

Mail merge starts with a clean data file, usually an Excel spreadsheet. Open Excel and create a new sheet. In the first row, type the column headers — these are the labels Word will recognize. Common headers are FirstName, LastName, Address, City, State, ZipCode, and EmailAddress. Type each header in its own cell across the top row.

Below the headers, enter the actual data. Put one person's information in each row. If you have 50 people to contact, you will have 50 rows of data plus the header row. Make sure the data is consistent: if one row has "New York" and another has "NY", Word will insert both versions, and your letters will look inconsistent. Check for extra spaces at the beginning or end of entries — these cause problems when Word tries to match fields.

Save your spreadsheet with a clear name like "MailMergeList.xlsx" in a folder you can find easily. Do not close it yet — you will need it open or at least saved when you set up Word.

Create Your Template in Word

Open a new Word document and write the letter or message you want to send. Type everything that will be the same for every recipient — the greeting, the body text, the closing. Where you would normally type a person's name or address, leave a blank space or type a placeholder like [FirstName] so you remember where the merge field goes.

For example, a template might look like this:

Dear [FirstName], Thank you for your interest in our program. We are writing to confirm your enrollment. Your mailing address on file is: [Address] [City], [State] [ZipCode] If this information is incorrect, please contact us. Sincerely, Program Director

Save this template with a clear name like "LetterTemplate.docx". You will use this file when you set up the merge in Word.

Connect Your Data to Word and Insert Merge Fields

With your template open in Word, click the Mailings tab at the top of the ribbon. Click Start Mail Merge and choose the type of document you are creating — Letters, Email Messages, Envelopes, or Labels. For a standard letter, choose Letters.

Next, click Select Recipients and choose Use an Existing List. Browse to your Excel file and open it. Word will ask which sheet contains your data — if you only have one sheet, it will select it automatically. Click OK.

Now go back to your template and delete the placeholder text like [FirstName]. Position your cursor where that information should go. Click Insert Merge Field (in the Mailings tab) and select the matching field from your data — in this case, FirstName. Word inserts the field as <<FirstName>>. Repeat this for every placeholder in your template: LastName, Address, City, State, ZipCode, and any other fields you need.

The merge fields now tell Word exactly where to pull information from your spreadsheet. When you run the merge, Word will replace each <<FirstName>> with the actual first name from the data file, and so on for every row.

Preview and Check Your Merged Results

Before you create the final merged documents, preview what they will look like. In the Mailings tab, click Preview Results. Word displays your template with the first person's data filled in. Use the arrow buttons to scroll through a few examples and check that the names, addresses, and other information appear in the correct places.

Look for common problems: names that are cut off, addresses that run into the wrong line, or fields that are blank when they should have data. If something looks wrong, click Preview Results again to turn off the preview, fix the template, and then turn the preview back on to check your changes.

If your data has errors — a missing last name or a misspelled city — you will see them here. You can go back to your Excel file, fix the data, and re-open the template. Word will ask if you want to reload the data source; click Yes.

Merge to a New Document or Send by Email

Once your preview looks correct, you have two main options. Merge to a new document creates one file with all the merged letters. Click Finish & Merge in the Mailings tab and choose Edit Individual Documents. Word creates a new document with all your letters, one after another, separated by page breaks. You can then print them all at once or review them individually before printing.

If you want to send merged emails instead of printing letters, your data must include an EmailAddress column. Click Finish & Merge and choose Send Email Messages. Word opens a dialog asking which field contains the email addresses — select EmailAddress. Choose whether to send the entire document or just specific pages, then click OK. Word sends each email to the addresses in your list.

For email merges, the subject line and message body come from your Word template. If you want different subject lines for different recipients, you will need to use a more advanced method, but for most cases, one subject line works fine.

Frequently Asked Questions

What if my data is in Google Sheets instead of Excel?

read your Google Sheet as an Excel file (.xlsx) first. Open Google Sheets, click File, then read, and select Microsoft Excel. Save the file to your computer, then use that file in Word's mail merge process.

Can I merge only some of the people in my list, not all of them?

Yes. After you preview your results, click Finish & Merge and choose Edit Individual Documents. In the dialog that appears, select Specific Records and enter the row numbers you want to merge — for example, 1-10 to merge only the first ten people. Click OK.

Why are some of my merge fields showing as blank?

The column header in your Excel file does not match the merge field name in Word. For example, if your Excel column is called "Email" but your merge field is "EmailAddress", Word cannot find the data. Check that your column headers in Excel match the field names you inserted in Word exactly, including capitalization.

Can I use mail merge to send emails through Outlook?

Word's mail merge can generate personalized emails, but it does not integrate directly with Outlook. Instead, merge to a new document, copy the text, and paste it into Outlook, or use the Send Email Messages option in Finish & Merge, which uses your default email program.

What happens if I accidentally close my template before finishing the merge?

Open the template file again. The merge fields are saved in the document, so they will still be there. Click Mailings, then Select Recipients, and choose your data file again. You can pick up where you left off.