How to Set Up a Mail Merge in Word From Excel List

You need to send personalized letters, emails, or labels to many recipients without typing each one by hand. Word can pull names, addresses, and other data from an Excel spreadsheet to fill in the blanks automatically. This feature is called Mail Merge and it saves hours of repetitive work. This article explains how to prepare your Excel list and complete the merge in Word step by step.

Understanding the Mail Merge Feature and Data Prerequisites

Mail Merge connects a Word document template with a data source, which in this case is an Excel worksheet. The Excel file acts as a list of records, where each row is a separate recipient and each column holds a specific piece of information such as First Name, Last Name, Address, City, or Email. Word reads this data and inserts it into placeholders called merge fields that you add to your document.

Before you begin, you must prepare the Excel list correctly. The most important rule is that the first row of the worksheet must contain column headers. These headers become the field names you will use in Word. For example, a column named “First Name” will create a merge field called «First_Name». The data rows must start in row 2 with no blank rows or columns inside the list. Save the Excel file and close it before you start the wizard in Word. If the file is open, Word cannot connect to it.

Steps to Run a Mail Merge from an Excel List in Word

The following steps use the Step-by-Step Mail Merge Wizard in Word. This is the easiest method for most users because it shows each stage in a separate pane.

1. Open Word and start the Mail Merge Wizard
   Open a new or existing Word document. Go to the Mailings tab on the ribbon. Click Start Mail Merge and select Step-by-Step Mail Merge Wizard. The Mail Merge pane opens on the right side of the window.
2. Select the document type
   In the wizard pane, choose the type of document you want to create. The options are Letters, E-mail Messages, Envelopes, Labels, or Directory. Select Letters for standard personalized letters. Click Next: Starting document at the bottom of the pane.
3. Choose the starting document
   Select Use the current document to work with the open document. Alternatively, you can start from a template or an existing document. Click Next: Select recipients.
4. Connect to your Excel data source
   In the wizard pane, select Use an existing list. Then click Browse. Navigate to your Excel file, select it, and click Open. The Select Table dialog box appears if your workbook contains multiple sheets. Choose the sheet that holds your data, such as Sheet1, and click OK. The Mail Merge Recipients dialog box opens showing all your records. You can clear checkboxes next to recipients you want to exclude. Click OK to confirm. Click Next: Write your letter.
5. Write the letter and insert merge fields
   Type the content of your letter in the document. Where you want personalized data to appear, place the cursor at that spot. In the wizard pane, click More items. The Insert Merge Field dialog box shows all your column headers. Select a field such as First_Name and click Insert. Repeat for each field you need. After inserting all fields, click Close. The fields appear as «First_Name» or similar placeholders. Click Next: Preview your letters.
6. Preview the merged letters
   The wizard shows the first recipient’s data in place of the merge fields. Use the left and right arrow buttons in the wizard pane to scroll through all records. If you see any errors, click Previous to go back and adjust the fields or the document. Click Next: Complete the merge.
7. Finish the merge
   In the wizard pane, you have two options. Click Print to send the merged letters directly to the printer. Click Edit individual letters to create a new Word document that contains all merged letters, each separated by a section break. This option lets you review, edit, or save the final output before printing.

Alternative Method: Mail Merge Without the Wizard

You can also run the merge directly from the ribbon without the wizard pane. On the Mailings tab, click Start Mail Merge and choose the document type. Click Select Recipients then Use an Existing List to choose your Excel file. Insert merge fields using the Insert Merge Field button on the ribbon. Preview with Preview Results and finish with Finish & Merge. This method is faster once you are familiar with the steps.

Common Mistakes and Limitations to Avoid

Excel file is open when Word tries to connect

Word cannot access the Excel file if it is open in Excel. Close the workbook completely before browsing for it in Word. If you need to edit the data, close the file first, make your changes, save, and then re-select it in Word.

Merge fields show blank or wrong data

This usually happens when the Excel column headers contain spaces, special characters, or are missing. Ensure every column has a unique header in the first row with no spaces. For example, use “FirstName” instead of “First Name” if you want to avoid potential issues, though Word handles spaces in headers correctly in most cases. Also check that the data rows do not contain empty cells in columns you are using.

Number formatting from Excel does not transfer correctly

Zip codes, phone numbers, and other numeric data may lose leading zeros or appear as numbers instead of text. To preserve formatting, format the column as Text in Excel before entering data. Right-click the column, choose Format Cells, select Text, and click OK. Then re-enter the data.

Only the first record appears in the final document

If you use the Edit Individual Letters option and see only one letter, you may have selected only the current record in the Merge to New Document dialog. When you click Finish & Merge then Edit Individual Documents, choose All in the dialog box instead of Current record or a range.

Word Desktop vs Word Online: Mail Merge Capabilities

Item	Word Desktop (Windows/Mac)	Word Online (Browser)
Mail Merge from Excel	Full support with wizard and ribbon tools	Not available
Insert merge fields	Available via Mailings tab	Not available
Preview results	Available	Not available
Finish and print or email	Available	Not available
Data source connection	Local Excel files, Access, Outlook contacts	Cannot connect to external data

Mail Merge is a desktop-only feature in Word. Word Online does not support connecting to external data sources or inserting merge fields. You must use the desktop version of Word to complete this task.

You can now set up a mail merge in Word using any properly formatted Excel list as your data source. Start by preparing the Excel file with column headers in the first row and no blank rows. Use the Mail Merge Wizard on the Mailings tab to connect the data, insert merge fields, and produce personalized documents. For advanced control, try the Finish & Merge > Send E-mail Messages option to send personalized emails directly from Outlook without printing.