What mail merge actually does

Mail merge takes a list of names, addresses, or other information from Excel and automatically fills those details into a template — usually a letter, email, or label — so you end up with dozens or hundreds of personalized copies without typing each one by hand.

The process works in three parts: your Excel spreadsheet holds the data (the names and addresses), your template document has blanks where that data goes, and the mail merge tool connects them and creates the final documents. You run it once and get all your copies at once.

This is useful for things like sending personalized letters to a mailing list, printing name tags for an event, creating envelopes with different addresses, or generating form letters where only certain details change between copies.

Key Takeaways

  • Mail merge requires two files: an Excel spreadsheet with your data organized in columns, and a template document (Word, Google Docs, or similar) with placeholder fields where the data goes.
  • The first row of your Excel sheet must contain column headers — the names that tell the merge tool which column holds addresses, which holds names, and so on.
  • In your template, you insert merge fields (special codes that reference your Excel columns) where you want the personalized information to appear.
  • Running the merge creates a new document with one copy for each row in your Excel sheet, with all the blanks filled in automatically.

Setting up your Excel spreadsheet correctly

Your Excel file needs to be organized in a specific way for mail merge to work. Each column should hold one type of information — one column for first names, one for last names, one for addresses, and so on. The very first row must contain headers: the names of those columns.

For example, if you are sending letters to people, your first row might say: FirstName, LastName, Address, City, State, ZipCode. Then each row below contains one person's information. Do not leave blank rows in the middle of your data, and do not put extra text or notes above the header row — the merge tool reads from the top and will treat those as data.

Save your Excel file before you start the merge. Most mail merge tools work best with .xlsx format (the standard Excel format), though some also accept .csv files. Close the file in Excel while you are setting up the merge in your template program — having it open in both places at once can cause problems.

How to set up mail merge in Microsoft Word

Open a new blank document in Word and write your template. This is the letter, label, or form that will be the same for everyone except for the personalized fields. Type out the full text, including the greeting, body, and closing.

Go to the Mailings tab at the top of Word. Click Start Mail Merge and choose the type of document you are creating — letters, envelopes, labels, or email messages. Then click Select Recipients and choose Use an Existing List. Navigate to your Excel file and open it. Word will ask which sheet to use (if your file has multiple sheets) and will show you a preview of the data.

Now click in your template where you want the first piece of personalized information to go. Click Insert Merge Field and select the column name from your Excel sheet — for example, FirstName. Word inserts a placeholder that looks like <<FirstName>>. Repeat this for each field you need: address, city, date, or whatever else changes between copies.

Once all your merge fields are in place, click Finish & Merge. Choose whether you want to edit individual documents before printing, print directly, or send as email. If you choose to edit first, Word creates a new document with all the merged copies so you can review them before printing.

Mail merge in Google Docs using a free add-on

Google Docs does not have built-in mail merge, but you can use a free add-on called Mail Merge for Gmail (made by Google) or Yet Another Mail Merge. Both work with Google Sheets instead of Excel, though you can upload your Excel file to Google Sheets first.

Open your Google Sheet with your data. Make sure the first row contains headers and each column holds one type of information, just as you would for Word. Then open a new Google Doc and write your template. Click the merge field where you want personalized information to appear.

In the add-on menu (click Extensions at the top, then find your mail merge add-on), select your Google Sheet and the column you want to insert. The add-on creates a placeholder in your template. Repeat for each field. When you are ready, run the merge and choose whether to create a new document with all copies or send them as individual emails.

Common mistakes that break mail merge

The most common problem is a mismatch between your column headers and your merge field names. If your Excel column says "Address" but you type <<address>> in Word (lowercase), the merge will not recognize it. Column names are case-sensitive in most mail merge tools, so check the spelling and capitalization carefully.

Another frequent issue is blank rows or extra text in your Excel file. If row 5 is blank, the merge will create a blank copy. If you have a title or note above your headers, the merge tool may treat that as data. Clean up your spreadsheet before you start: delete blank rows, remove any text that is not part of the actual data, and make sure your headers are in row 1.

Leaving your Excel file open while running the merge can also cause errors. Close it completely in Excel before you run the merge in Word or Google Docs. Some mail merge tools lock the file while reading it, and having it open elsewhere prevents that.

What happens after the merge completes

When you finish the merge, you have a new document (or set of documents) with all the personalized copies. In Word, you can review them, make edits to individual copies if needed, and then print or save them. In Google Docs, the add-on typically creates a new document or sends emails directly, depending on which option you chose.

If you need to make changes to the template itself — fixing a typo in the letter, changing the date, or adding a new field — go back to your original template document, make the change, and run the merge again. The merge does not modify your original files; it only creates new output based on what you have set up.

Frequently Asked Questions

Can I use mail merge to send personalized emails?

Yes. In Word, you can choose Email Messages as your merge type, and the merge will create individual emails with personalized content. In Google Docs, the Yet Another Mail Merge add-on can send emails directly to addresses in your spreadsheet. You will need an email address column in your Excel sheet for this to work.

What if I only want to merge to some of the rows in my spreadsheet, not all of them?

In Word, after you select your recipients, click Edit Recipient List. You can uncheck the rows you do not want to include, and the merge will skip them. In Google Docs, you can delete or hide rows in your sheet before running the merge, or some add-ons let you filter which rows to include.

Can I merge data from multiple Excel sheets at once?

Most mail merge tools work with one sheet at a time. If your data is split across multiple sheets, combine it into a single sheet first. Copy and paste the data from one sheet into another, or use Excel's consolidation features if the sheets have the same structure.

What file formats does mail merge work with?

Word mail merge works best with .xlsx (Excel format) and .csv (comma-separated values). Google Docs mail merge add-ons work with Google Sheets. If you have data in another format, you can usually open it in Excel or Google Sheets and save it in one of these formats before merging.