What mail merge does

Mail merge is a feature that takes a list of names, addresses, or other information from one place and automatically inserts each piece into a template document. In Excel, you are usually the source of the data — the spreadsheet holds the list — and you merge it into a Word document, email, or letter template to create personalized copies without typing each one by hand.

The most common use is creating form letters: you have a spreadsheet with 50 customer names and addresses, and a letter template that says "Dear [Name]," and mail merge fills in each name automatically, producing 50 different letters. You can also use it to generate mailing labels, envelopes, or email messages where the content changes for each recipient.

Mail merge is not a feature that lives only in Excel — Excel provides the data, but the actual merging usually happens in Word or Outlook. However, understanding how to set up your Excel list correctly is the first step, because a poorly organized spreadsheet will break the entire process.

Key Takeaways

  • Mail merge pulls information from an Excel spreadsheet and inserts it into a Word template, creating a personalized copy for each row in your list.
  • Your Excel spreadsheet must have column headers in the first row, with each piece of information (name, address, email) in its own column.
  • The merge itself happens in Word or Outlook, not in Excel, using the Mail Merge Wizard under the Mailings tab.
  • Common mistakes include blank rows in your data, inconsistent formatting, or column headers that contain spaces or special characters.

How to organize your Excel data for mail merge

Before you open Word, your Excel spreadsheet must be organized in a specific way. The first row should contain column headers — the names of the information categories. For example: FirstName, LastName, Email, Address, City, State, ZipCode. Each column holds one type of information, and 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 names, rows 2 through 51 should all contain data, with no empty rows between them. Mail merge will treat a blank row as the end of your list and stop processing. Similarly, do not put extra information or notes in rows above your headers — start your headers in row 1.

Keep your column headers straightforward and avoid spaces or special characters. Use FirstName instead of "First Name" or "First_Name". This matters because Word will reference these headers by name when you set up the merge, and spaces or symbols can cause errors. Save your Excel file before you move to Word — mail merge reads the file from disk, not from the open spreadsheet.

Setting up the merge in Word

Open Word and create or open the template document you want to merge into. This is the letter, label, or email that will be the same for everyone except for the personalized fields. Type the static text first — the greeting, body, closing — and leave blank spaces where the personalized information will go.

Go to the Mailings tab at the top of Word. Click Start Mail Merge and choose the type of document you are creating: Letters, Email Messages, Envelopes, Labels, or Directory. Then click Select Recipients and choose Use an Existing List. Navigate to your Excel file and open it. Word will ask you which sheet contains your data — if you only have one sheet, it will select it automatically.

Word will then show you a preview of your data to confirm it recognized the headers correctly. If the preview looks wrong — for example, if it is treating your headers as data — go back and fix your Excel file. Once the preview is correct, click OK.

Inserting merge fields into your template

Now you are back in your Word document. Click in the spot where you want the first piece of personalized information to appear. Go to Mailings and click Insert Merge Field. A dropdown menu will show all the column headers from your Excel file. Click the one you want — for example, FirstName — and Word will insert it as a placeholder that looks like <<FirstName>>.

Repeat this for each piece of information you need. If your template says "Dear [Name]," you might insert <<FirstName>> <<LastName>>. If you are creating mailing labels, you would insert FirstName, LastName, Address, City, State, and ZipCode in the correct order on the label template.

You can type regular text around the merge fields. For example: "Dear <<FirstName>>," or "123 Main Street, <<City>>, <<State>> <<ZipCode>>." The merge fields will be replaced with actual data when you run the merge.

Running the merge and saving the output

Once your template is complete with all the merge fields in place, go to Mailings and click Finish & Merge. You have three options: Edit Individual Documents (creates one new Word document with all the merged letters), Print Documents (sends them directly to your printer), or Send Email Messages (if you are merging email addresses).

Most people choose Edit Individual Documents first, so they can review the output before printing or sending. Word will create a new document with one copy of the letter for each row in your Excel file. You can then scroll through, check for errors, and make any last-minute changes before you print or send.

If you choose to print directly, Word will print one copy for each record without creating a new document. If you choose to send emails, Word will open Outlook and create one email message for each recipient, with the merge fields filled in. You can review each one before sending, or send them all at once.

Common problems and how to fix them

If Word says it cannot find your Excel file, make sure the file is saved and closed. Mail merge reads from the saved file on disk, not from a file that is currently open in Excel. If you made changes to your Excel data after you started the merge, close Word without saving, reopen your Excel file, save it, and start the merge again in Word.

If the merge fields are not filling in with data, check that your column headers in Excel match exactly what you inserted in Word. If your Excel header is "FirstName" but you inserted the field "First Name" (with a space), Word will not find it. Go back to Word, delete the incorrect field, and insert the correct one from the dropdown.

If some records are missing from the output, check your Excel file for blank rows. Delete any empty rows between your data, save the file, and run the merge again. If the formatting looks wrong — for example, if names are appearing in the wrong place or addresses are split across lines — adjust the spacing and line breaks in your Word template before you merge.

When mail merge is the right choice

Mail merge saves time when you have more than a handful of personalized documents to create. If you need to send 10 letters with different names, mail merge is overkill — typing them individually is faster. If you need to send 100 letters, mail merge is worth the setup time.

Mail merge also works best when the information you are personalizing is already in a structured list — a customer database, a contact list, a roster of names and addresses. If the information is scattered across different files or formats, you will spend more time organizing it than you would save by merging.

For very large projects or complex formatting, some people use mail merge alternatives like mail merge templates in Google Docs, third-party tools like WhereoWare or Mailmodo, or custom scripts in Excel itself. But for straightforward letters, labels, and envelopes, the built-in Word mail merge feature is free and does the job.

Frequently Asked Questions

Can I use mail merge with Gmail or other email services?

Word's mail merge can send emails through Outlook, but not directly through Gmail. If you use Gmail, you can export your merged letters as a document and copy them into individual emails, or use a third-party tool like Gmail merge extensions. Some people also use Google Docs, which has a built-in mail merge feature that works with Google Sheets.

What if I only want to merge some of the records, not all of them?

In Word, after you select your data, click Edit Recipient List and uncheck the rows you do not want to include. Only the checked rows will be merged. Alternatively, you can create a separate Excel file with only the records you need and use that as your data source.

Can I merge into an Excel spreadsheet instead of Word?

Not with the standard mail merge feature. Mail merge is designed to create documents (letters, labels, emails), not to populate cells in another spreadsheet. If you need to combine data from two Excel files, you would use formulas like VLOOKUP or INDEX/MATCH instead.

Do I need to save the merged document, or can I print it and throw it away?

You can do either. If you save the merged document, you have a record of what was sent. If you only need to print it once, you can print directly from the merge and close without saving. Keep in mind that if you close without saving, you cannot undo the merge or make changes later.

What happens if my Excel data changes after I have already merged?

The merged document does not update automatically. If your Excel data changes, you need to run the merge again with the updated file. The old merged document will still have the old information unless you manually edit it or create a new merge.