What Mail Merge Does and Why You Need It

Mail merge takes a list of names, addresses, or email details from a spreadsheet and automatically fills them into a template letter or email in Word. Instead of typing each person's name and address by hand, you create one document with placeholder fields, connect it to your data list, and Word generates a separate version for each person.

The most common use is printing personalized letters — you write one letter with blanks where names go, point Word to a spreadsheet of recipients, and it prints 50 copies with each person's details filled in. You can also use mail merge to create personalized emails, labels, or envelopes. The time savings grows with your list size: a 10-person job saves maybe 15 minutes, but a 500-person job saves hours.

Key Takeaways

  • Mail merge requires two files: a Word template with placeholder fields and a data source (usually an Excel spreadsheet with one row per person).
  • Your data source must have column headers in the first row — Name, Email, Address — and each person's information in the rows below.
  • You insert merge fields into your Word template by going to the Mailings tab and clicking Insert Merge Field for each placeholder you need.
  • After inserting merge fields, you preview the merged results to catch errors before generating all copies.
  • The final step produces either individual documents, a single combined document, or printed pages depending on what you are sending.

Set Up Your Data Source in Excel

Mail merge starts with clean data. Open Excel and create a new spreadsheet with one row of column headers at the top. Use simple, clear names: FirstName, LastName, Email, Address, City, State, ZipCode — whatever fields your letter or email needs. Do not leave any header cells blank, and do not skip rows.

Enter each person's information in the rows below, one person per row. Check for typos and extra spaces before you save — mail merge will copy mistakes exactly as they appear. Save the file as an Excel spreadsheet (.xlsx) in a folder you can find easily. You will need to locate this file when you set up the merge in Word, so remember where you put it.

If your data is already in a different format — a CSV file, a Google Sheet, or even a Word table — you can use that instead. Excel is the most reliable choice, but Word can connect to other sources. For now, stick with Excel if you have the option.

Create Your Template in Word

Open a new Word document and write the letter or email text exactly as you want it to appear, except where you need personalized information. For example, write "Dear [name goes here]," or "We are sending this to [address goes here]." Do not insert the actual names or addresses yet — you are just marking where they belong.

Format the document the way you want the final version to look: add your letterhead, set margins, choose fonts, add a signature line. Everything except the personalized fields should be finished before you start the merge. Save this document with a clear name like "Letter Template" or "Email Template" in the same folder as your data file.

Insert Merge Fields Into Your Template

Click the Mailings tab at the top of Word. On the left side, click Start Mail Merge and choose the type of document you are creating — Letters, Email Messages, Envelopes, or Labels. Word will ask you to confirm your document type.

Next, click Select Recipients and choose Use an Existing List. Navigate to your Excel file and open it. Word will show you a preview of your data to confirm it found the right file and the right columns.

Now go back to your template and position your cursor where the first personalized field should go. Click Insert Merge Field (in the Mailings tab) and select the column name from your spreadsheet — for example, FirstName. Word inserts a placeholder that looks like <<FirstName>>. Repeat this for every field you need: click where you want the last name, insert LastName, click where you want the address, insert Address, and so on.

Do not type the angle brackets or the field names yourself — always use the Insert Merge Field button. If you type them by hand, Word will not recognize them as merge fields and will not fill them in.

Preview and Check Your Merged Results

Before you generate all your documents, preview what the merge will actually produce. In the Mailings tab, click Preview Results. Word shows you the first person's information filled into your template. Use the arrow buttons to scroll through a few examples and check that names, addresses, and other details are in the right places and spelled correctly.

If you see a problem — a field in the wrong spot, a missing space between fields, or a typo in your data — go back and fix it. If the problem is in your data, close the preview, fix the Excel file, and re-select your recipients. If the problem is in your template, move the merge fields or adjust the text around them. Always preview before you finish the merge.

Complete the Merge and Generate Your Documents

Once the preview looks correct, click Finish & Merge in the Mailings tab. You have three options: Edit Individual Documents, Print Documents, or Send Email Messages.

Choose Edit Individual Documents if you want to review or make small changes to each letter before printing or sending. Word creates a new document with all the merged letters combined, one after another. You can edit any letter, delete ones you do not need, or add notes. Save this file with a new name so you do not overwrite your template.

Choose Print Documents if you are printing physical letters and want to send them straight to your printer. Word will print one copy of each letter with all the personalized information filled in.

Choose Send Email Messages if you are sending emails. Word will ask which column contains the email addresses (usually Email) and what you want the subject line to say. It then opens your default email program and creates one message per person with the merge fields filled in. You can review and send them one at a time, or your email program may have an option to send them all at once.

Troubleshoot Common Merge Problems

If merge fields show as <<FieldName>> instead of actual names and addresses, the merge did not run. Make sure you clicked Finish & Merge and chose one of the three options. If you see the field codes instead of the results, press Ctrl+A to select all, then press Ctrl+Shift+F9 to convert the codes to actual data.

If some fields are blank or show "Error: No data source," Word lost the connection to your Excel file. The file may have been moved, renamed, or deleted. Go back to Select Recipients, choose Use an Existing List, and navigate to your data file again. Make sure the file is still in the same location and has not been renamed.

If names or addresses are cut off or run into other text, adjust the spacing around your merge fields in the template. Add line breaks or extra spaces between fields if needed, then preview again to see the result. Remember that different names have different lengths — "Bob" takes less space than "Christopher" — so leave room for variation.

Frequently Asked Questions

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

Yes, but Word will open your default email program (Outlook, Gmail, etc.) and create one message per person. You can review each email before sending, but you cannot send them all at once from Word itself. If you need to send hundreds of emails, a dedicated email service like Mailchimp or Constant Contact is faster and more reliable.

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

Download your Google Sheet as an Excel file (.xlsx) and save it to your computer. Then use that file for your mail merge. Word cannot connect directly to Google Sheets, so downloading is the easiest workaround.

Can I merge to labels or envelopes instead of letters?

Yes. When you click Start Mail Merge, choose Labels or Envelopes instead of Letters. Word will ask you to select your label or envelope size, then you insert merge fields the same way. This is useful for printing address labels or envelope addresses for bulk mailings.

What happens if I edit the template after I have already merged once?

The merged documents you already created will not change. If you edit the template and want to merge again with the same data, just repeat the process from the Mailings tab. You can merge the same template multiple times with different data sources or the same data source if it has been updated.

Can I merge only some rows from my data, not all of them?

Yes. Before you click Finish & Merge, go to Edit Recipient List in the Mailings tab. Uncheck the boxes next to any rows you want to skip, and the merge will only process the checked rows. This is useful if you want to send to a subset of your list without creating a separate data file.