How to Mail Merge in Word 2010: A Step-by-Step Guide

To mail merge in Word 2010, open the Mailings tab, choose Start Mail Merge or Step-by-Step Mail Merge Wizard, connect a recipient list, insert merge fields, preview the results, and select Finish & Merge. Mail merge combines one main document with a list of names or other information to create personalized letters, envelopes, labels, or email messages. Before you begin, prepare a clean recipient list and decide which type of document you need.

What You’ll Need

Word 2010 for Windows, with a blank or existing document. The instructions below use the Word 2010 ribbon.
A recipient list. This can be an Excel workbook, an Outlook contacts list, a Word table, or another supported data source. Excel is a common choice for lists with multiple fields.
Clear column headings for every piece of information you may insert, such as FirstName, LastName, Address, City, and Email. Each row below the headings should represent one recipient.
A printer and suitable paper or labels if you intend to print. For an email merge, Outlook must be installed and configured with an account that can send messages.

Step-by-Step

Prepare and save the recipient list. In Excel, put each type of information in its own column, with a single heading in the first row and one recipient per row. For example, use separate columns for FirstName, LastName, Street, City, State, PostalCode, and Email. Remove completely blank rows within the list, check for spelling errors, and make sure every recipient has the information needed for the document. Save the workbook in a location you can find, then close Excel before connecting it to Word. If postal codes include leading zeros, store them as text so Excel does not remove those zeros.

A simple list might have the headings FirstName, LastName, and Email on row 1, followed by recipient details on rows 2 and onward. Do not combine a heading and data in one cell, put two recipients in one row, or use merged cells in the list. A well-organized source makes it easier to identify the right fields later.
Choose the type of merge. Open Word 2010 and either open the document you want to use as the template or create a new one. Select the Mailings tab. Choose Start Mail Merge and select Letters, E-mail Messages, Envelopes, or Labels, as appropriate. For guided instructions, choose Start Mail Merge > Step-by-Step Mail Merge Wizard. The wizard opens a task pane on the right and walks through the same main choices one at a time.

Letters are useful when each recipient needs a separate document with personalized details. Choose labels when you want a sheet of repeated recipient labels. Email messages create a separate personalized email for each selected recipient; they do not create individual attachments.
Choose or set up the main document. If you chose Letters, the wizard asks how you want to use the document. Select Use the current document to keep your open file, Start from a template to use a Word template, or Start from existing document to use another file. Follow the pane’s instructions and click Next at the bottom when ready.

For envelopes, Word asks you to set envelope options, including size and address placement. For labels, choose Label options, select the label vendor and product number printed on the package, and confirm the layout. The document will display the label cells; do not type a different design into every cell because Word will repeat the first label during the merge.
Connect the recipient list. In the wizard, choose Use an existing list, then select Browse. Locate and open your Excel workbook. If prompted, select the worksheet or named range that contains the recipient data, and confirm that the first row contains column headers if that option appears. Check the recipient list in the dialog box and clear the check box beside anyone who should not receive the document. Click OK to attach the list.

You can instead choose Select from Outlook contacts or Type a new list when those options suit your situation. Word may show a list of available tables or worksheets; select the one that actually contains the data, not a blank sheet. To change or filter recipients later, use Mailings > Edit Recipient List.
Write the shared text and insert merge fields. Type the portions of the letter or message that will be the same for everyone. Click where personalized information should appear. In the wizard, choose More items to select a field such as FirstName or City, then click Insert and close the dialog. On the ribbon, you can also use Mailings > Insert Merge Field. Add punctuation and spaces around fields as needed; Word inserts a field, not the spaces that make a sentence read naturally.

For example, type “Dear ”, insert the FirstName field, then type a comma and press Enter before writing the shared message. The document may show a placeholder such as «FirstName» rather than a real name. That is expected. You can use Mailings > Address Block to insert a formatted postal address or Mailings > Greeting Line to build a salutation, then review the matching options if the preview does not identify your columns correctly.

For labels, arrange the first label with the address block or individual fields. Then select Mailings > Update Labels so Word copies the layout and adds the required next-record fields to the other label cells. If you are using the wizard, follow its prompt to replicate the first label across the sheet.
Preview the merged documents. Select Mailings > Preview Results, or use the preview option in the wizard. Word replaces the field names with the information from one recipient. Use the left and right arrow buttons in the Mailings tab to move through records. Check several records, including the first and last, and look for missing names, awkward spacing, wrong addresses, and data appearing in the wrong place.

Use Edit Recipient List to exclude someone or correct which records are selected. If a field shows the wrong column, return to the document and insert the correct merge field. Previewing is important even for a short list: a field can be valid but still produce an unintended result when a source cell is empty.
Complete the merge and choose an output. When the preview looks right, select Mailings > Finish & Merge. Choose Edit Individual Documents to create a new Word document containing the merged copies, Print Documents to send the results to a printer, or Send E-mail Messages for an email merge.

For Edit Individual Documents, choose all records or a record range in the dialog box and click OK. Review the resulting document, then save it under a new name. This is often the safest option because you can inspect the completed copies before printing. For printing, choose the record range and confirm the printer and paper settings. For email, choose the email-address field, enter a subject line, and select a mail format. Word uses Outlook to send the messages, so check the selected recipients and message carefully before confirming.

After finishing, keep the original template and recipient list. The merged output is a separate result; changing it does not automatically update the source list or template. Save a copy of the finished document if you need a record of exactly what was produced.

Common Mistakes

Using a messy source list: Blank rows, duplicate headings, merged cells, or extra notes above the headings can cause Word to show the wrong range or omit records. Keep the list rectangular, with one header row and one recipient per row. If Word asks which worksheet to use, verify the selection rather than choosing the first item automatically.

Inserting ordinary text instead of a merge field: Typing FirstName into the letter will print that word literally. Insert the field through Mailings > Insert Merge Field or the wizard’s More items option. Likewise, check that spaces and punctuation around fields are present.

Skipping preview: A document can look correct with field names showing and still produce incorrect results. Preview multiple recipients and inspect the final merged document before printing a large job or sending email.

Choosing the wrong label stock or email field: A mismatched label product number can misalign an entire sheet. Selecting a name field rather than the email-address field can prevent an email merge from sending. Check the product number on the label packaging and the chosen field in the email dialog.

Tips

Give source columns short, descriptive headings without duplicate names, such as FirstName and PostalCode. Keep the template, source workbook, and finished output in clearly named files, and retain an untouched copy of the source. If an address or name is optional, decide how blank values should read before merging; for instance, avoid a salutation that leaves an unwanted space or comma when a first name is missing.

Use Edit Individual Documents for a high-stakes or large print run. It lets you inspect the combined output, correct a particular copy if necessary, and save the result before using paper. When working with labels, print a test page on plain paper first. Hold it behind a label sheet against a light to check alignment before printing onto the actual labels.

Word 2010 may display dates or numbers in a format different from the way they appear in Excel. If a merged date needs a particular style, preview it and adjust the Word merge field formatting rather than assuming Excel’s display format will carry over. Keep a note of any formatting changes so you can repeat them if you reuse the template.

Troubleshooting

The workbook or worksheet is missing: Confirm that you selected the correct file and that the list is saved. In the selection dialog, choose the worksheet containing the headers and recipient rows. If the list is not detected correctly, remove blank rows or columns around it, save the workbook, close Excel, and reconnect it using Mailings > Select Recipients > Use Existing List.

Word shows «FirstName» instead of a person’s name: Field codes are normally visible before preview. Select Mailings > Preview Results. If the placeholder remains, confirm that the recipient list is connected and that the field name matches a column heading. Use Insert Merge Field to replace an incorrect field.

Some recipients are missing: Open Mailings > Edit Recipient List and check the selection boxes and any filters. Confirm that the missing records are within the chosen worksheet or data range and that there are no blank rows interrupting the list. In the Finish & Merge dialog, make sure you selected all records rather than a limited range.

Labels print out of alignment: Recheck the label vendor and product number under Mailings > Start Mail Merge > Labels or the wizard’s label options. Confirm that the printer uses the correct paper size and that scaling is not set to fit the page. Print a plain-paper test, then compare it with the label sheet. If only the first label contains an address, use Update Labels after laying out the first cell.

Email merge does not send: Verify that Outlook is installed, has a sending account configured, and is available to Word. In the email merge dialog, select the column that contains valid email addresses and check the subject and format. If Outlook displays a security prompt or an error, follow the prompt and check Outlook’s account and connection settings; Word cannot send through an invalid or unavailable account.

Frequently Asked Questions

Can I mail merge from an Excel list in Word 2010?
Yes. Choose Mailings > Select Recipients > Use Existing List, browse to the workbook, and select the worksheet or range containing the list. Use headings in the first row and one recipient per row.

Can I make labels with Word 2010 mail merge?
Yes. Choose Mailings > Start Mail Merge > Labels, select the label vendor and product number, connect your recipients, and add the address fields to the first label. Choose Update Labels to fill the remaining label positions with the merge layout.

Can I send a separate personalized email to every person?
Yes. Select E-mail Messages as the merge type, connect a list with an email column, and insert fields into the message. Finish with Send E-mail Messages. Outlook must be configured, and Word sends the message to each selected recipient rather than creating a document attachment for each person.

How do I print just a few records?
Use Mailings > Edit Recipient List to select or filter recipients. When you choose Finish & Merge, you can also specify a record range in the dialog box. Preview the selected records before printing.

Can I reuse the merge template?
Yes. Save the Word template and keep the source list available. When you reopen the template, confirm or reconnect the recipient list, update the data if needed, and preview the new results before completing the merge.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.