What a mail merge actually does

A mail merge takes a list of names and addresses from Excel and automatically fills them into a Word document template. Instead of typing each recipient's details by hand into dozens of letters, you create one template with placeholder fields, connect it to your Excel list, and Word generates a separate document for each person in seconds.

The practical result: you write "Dear [FirstName]" once, and Word produces "Dear Sarah", "Dear Marcus", "Dear Jennifer" — one for each row in your spreadsheet. This works for letters, envelopes, labels, or email messages. The Excel file is the data source; the Word document is the template that uses it.

Key Takeaways

  • Your Excel file needs column headers in the first row (Name, Address, Email) and one person per row below that.
  • In Word, you insert merge fields that match your Excel column names exactly, and Word replaces them with actual data when you run the merge.
  • You start the merge from Word, not Excel — Word is the tool that pulls data in and creates the final documents.
  • The merge creates a new document with all the personalized letters; you can print them, email them, or save them as separate files.

Setting up your Excel file correctly

Open Excel and create a new spreadsheet. The first row must contain headers — these are the labels that Word will look for. Type "FirstName" in A1, "LastName" in B1, "Address" in C1, "City" in D1, and any other information you need. Use no spaces in header names; "FirstName" works, but "First Name" will cause problems later.

Starting in row 2, enter one person per row. Put Sarah's first name in A2, her last name in B2, her address in C2, and so on. Continue until you have entered everyone. Do not leave blank rows in the middle of your list — Excel will stop reading when it hits an empty row. Save this file with a clear name like "MailMergeList.xlsx" in a folder you can find easily.

Creating your Word template with merge fields

Open a new Word document and write the letter or document you want to send. Type the body exactly as you want it to appear, but where you need a person's name or address, you will insert a merge field instead of typing it by hand.

To insert a merge field, go to the Mailings tab at the top of Word. Click Select Recipients, then choose Use an Existing List. Navigate to your Excel file and open it. Word will read the headers from your spreadsheet.

Now click in your document where you want the first name to appear. Go to Mailings again and click Insert Merge Field. A dropdown menu shows all the headers from your Excel file. Click FirstName. Word inserts the text «FirstName» in your document — this is the placeholder that will be replaced with actual names during the merge.

Continue this way for every field you need. If your letter says "Dear [FirstName] [LastName]", click after "Dear " and insert FirstName, type a space, then insert LastName. The document now reads "Dear «FirstName» «LastName»" with the angle brackets showing these are merge fields, not regular text.

Running the merge and creating the final documents

Once your template is complete with all merge fields in place, go to Mailings and click Finish & Merge. You have three options: Edit Individual Documents, Print Documents, or Send Email Messages.

If you choose Edit Individual Documents, Word creates a new document containing all the merged letters — one after another, each with the correct name and address filled in. You can scroll through, check that everything looks right, and make changes to individual letters if needed. Save this document when you are done.

If you choose Print Documents, Word sends all the letters directly to your printer without creating a separate file. This is fastest if you are printing when ready and do not need to review first.

If you choose Send Email Messages, Word uses the email addresses in your Excel file to send personalized emails. You must have an email column in your spreadsheet for this to work.

Fixing the most common mistakes

The merge field name does not match the Excel header. If your Excel column says "First_Name" but you insert a merge field called "FirstName", Word will not find the data and will leave the field blank. Always check that the merge field name matches the header exactly — same spelling, same capitalization, same underscores or spaces.

Blank rows in the Excel list. If row 5 is empty, Excel stops reading at row 4 and ignores everyone below. Delete any blank rows before you start the merge.

The merge fields are not updating. After you run the merge, the new document shows «FirstName» instead of actual names. This usually means Word did not connect to the Excel file correctly. Go back to Mailings, click Select Recipients, and choose your Excel file again. Then run the merge a second time.

When to use mail merge instead of other methods

Mail merge is worth the setup time when you are sending more than about ten personalized documents. For three or four letters, typing names by hand is faster. For a hundred letters, mail merge saves hours.

Mail merge also works best when the information is already in a spreadsheet — if you have a customer list in Excel or a contact database you can export as Excel, you are already halfway done. If the names exist only in an email list or a Word table, you would need to copy them into Excel first, which adds a step.

If you need to personalize only the name and address, mail merge is straightforward. If you need to change the entire structure of the letter based on the person (different paragraphs for different regions, different prices for different customers), mail merge becomes complicated and a different tool might be better.

Frequently Asked Questions

Can I merge to email instead of printing?

Yes. Your Excel file must have an email column with addresses in it. During the merge, choose Send Email Messages instead of Edit Individual Documents or Print Documents. Word will send each person their personalized letter as an email.

What if I need to merge only some of the people in my list?

After you select your Excel file, go to Mailings and click Edit Recipient List. You can uncheck the names you do not want to include. Only the checked names will be merged into the final document.

Can I save each merged letter as a separate file?

Not directly from the merge dialog. Run the merge to create one document with all letters, then use File > Save As and save it. You will have one file containing all the letters. To split them into separate files, you would need to manually cut and paste each letter into its own document, or use a more advanced mail merge tool.

What happens if my Excel file has special characters or accents?

Word handles accented letters and special characters correctly as long as your Excel file is saved as .xlsx or .csv. The merge will preserve them in the final document. Test with one letter first to make sure the formatting looks right.

Do I need to keep the Excel file open while I merge?

No. Word reads the Excel file once when you select it, then creates the merged document. You can close Excel before you run the merge. The Excel file and Word document should stay in the same folder or in folders you can navigate to, but they do not need to be open at the same time.