What Mail Merge Does and Why You Need It

Mail merge pulls names, addresses, and other details from an Excel spreadsheet into a Word document template, so you can create dozens of personalized letters, emails, or labels without typing each one. Instead of writing "Dear John" in one letter and "Dear Sarah" in another, you write the letter once with a placeholder, and Word fills in each person's name automatically.

The process saves time when you're sending the same message to many people but want each copy to feel personal. Common uses include form letters to clients, invitations with individual names, mailing labels, or email messages with custom details. Excel holds the data, Word holds the template, and mail merge connects them.

Key Takeaways

  • Your Excel file must have column headers in the first row, with each column containing one type of information (FirstName, LastName, Address, and so on).
  • In Word, you insert merge fields — placeholders like <<FirstName>> — that pull data from your Excel columns.
  • Word's Mail Merge Wizard walks you through selecting your Excel file, choosing which records to use, and previewing the results before printing or saving.
  • You can merge to a new document (creating individual letters you can edit), to email, or directly to a printer.

Setting Up Your Excel Data Correctly

Excel must be organized in a specific way for mail merge to work. The first row should contain column headers — single words or short phrases that describe what each column holds. Use headers like FirstName, LastName, Address, City, State, ZipCode, Email, or Company. Do not leave the first row blank, and do not merge cells in the header row.

Each row below the headers represents one person or record. If you have 500 people to mail to, you will have 500 rows of data plus one header row. Keep the data clean: remove extra spaces at the start or end of entries, and use consistent formatting (for example, all states as two-letter abbreviations, not spelled out). If a person does not have an email address, leave that cell empty rather than typing "N/A" or "none" — Word will handle blanks better during the merge.

Save your Excel file before moving to Word. Use a straightforward filename without special characters, and keep the file in a folder you can find easily. Close the file in Excel; Word will open it automatically during the merge process.

Creating Your Word Template with Merge Fields

Open a new Word document and write the letter, email, or document you want to send. Write it as if you are sending it to one person, but use placeholders where personal details should go. For example, instead of writing "Dear John," write "Dear <<FirstName>>,". Instead of a specific address, write "<<Address>> <<City>>, <<State>> <<ZipCode>>."

To insert a merge field in Word, go to the Mailings tab at the top of the ribbon. Click Insert Merge Field and select the column name from your Excel file. Word will insert it as <<ColumnName>>. Do not type the angle brackets yourself — always use the Insert Merge Field button, because Word needs the proper formatting to recognize the field during the merge.

Format your template the way you want the final letters to look. Change fonts, add your company logo, adjust spacing, and include any standard text that will appear in every letter. The only parts that will change from letter to letter are the merge fields.

Running the Mail Merge Step by Step

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

Next, click Select Recipients and choose Use an Existing List. Navigate to your Excel file and open it. Word will ask which sheet contains your data (usually Sheet1) and confirm that the first row contains headers. Click OK.

Now click Preview Results to see what your letters will look like with real data. Use the arrow buttons to flip through a few examples and check that names, addresses, and other details are appearing in the right places. If something looks wrong, go back and fix your template or your Excel data, then start the merge again.

Finishing the Merge and Saving or Printing

Once the preview looks correct, click Finish & Merge. You have three options: Edit Individual Documents creates a new Word file with all the merged letters, one after another, so you can review and edit them before printing. Print Documents sends them straight to your printer. Send Email Messages creates individual emails if you set up an email merge field.

For most situations, choose Edit Individual Documents. Word will create a new document called "Letters1" or similar, containing every personalized letter. You can then scroll through, make any last-minute changes, and save the file. If you need to print, you can print all pages at once or select specific pages.

If you choose Print Documents, Word will ask which records to print — all of them, or a range. Select all, and Word will print each letter on a separate page. If you choose Send Email Messages, Word will open your default email program and create one message per person, using the email addresses from your Excel file.

Fixing Common Problems

If merge fields show as <<FieldName>> instead of actual data, the fields may not be linked to your Excel file correctly. Go back to Select Recipients, choose your Excel file again, and run the preview. If the problem persists, close Word without saving, reopen your template, and start the mail merge from the beginning.

If some records are missing or you only want to merge certain people, click Edit Recipient List in the Mailings tab. You can uncheck the boxes next to names you want to skip, or sort and filter the list. This is useful if you want to send letters only to people in a certain state or with a certain status.

If your Excel file has been updated since you started the merge, close the Word template, save and close the Excel file, then reopen the Word template and start the merge again. Word will pull the latest data from Excel.

Frequently Asked Questions

Can I merge data from multiple Excel sheets at once?

No, mail merge works with one sheet at a time. If your data is split across sheets, copy all the data into a single sheet first, making sure the headers match. Then save the file and run the merge.

What if I want to merge only certain columns from my Excel file?

You do not have to use every column. straightforward insert merge fields only for the columns you need. The unused columns will be ignored during the merge. If you want to clean up your Excel file, you can delete unused columns before starting the merge.

Can I edit individual letters after the merge is done?

Yes. Choose Edit Individual Documents when you finish the merge. Word creates a new document with all the letters, and you can edit any of them. Once you edit a merged document, it is no longer connected to the merge — changes are permanent and will not affect future merges from the same template.

How do I merge to email instead of printing?

Choose Email Messages when you start the mail merge, and insert an email merge field for the recipient's email address. When you finish, select Send Email Messages. Word will create one email per person using your default email program. Make sure your Excel file has a column with email addresses.

What happens if I run the same mail merge twice?

Each time you run the merge, Word creates a new document or sends new emails. If you merged to a new document the first time, running the merge again creates a separate new document. The original merged document is not affected. You can keep multiple merged documents if you need different versions.