How to Use Microsoft Word Mail Merge with Excel Data

If you need to send a personalised letter, email, or invoice to dozens or hundreds of different people, manually copying and pasting names and addresses is highly inefficient and prone to errors. Microsoft Word solves this problem elegantly through a feature called Mail Merge.

Mail Merge allows you to take a single template document in Microsoft Word and automatically populate it with unique data pulled directly from a Microsoft Excel spreadsheet. In this guide, you will learn how to execute a flawless Mail Merge.

Step 1: Prepare Your Excel Data Source

The success of a Mail Merge depends entirely on how well your Excel data is formatted. Word uses the column headers in your spreadsheet to know where to place the data.

1. Open Excel and create a new spreadsheet.
2. In the very first row (Row 1), create clear, descriptive headers. Do not leave empty rows at the top. For example: First Name, Last Name, Company, Email, Amount Due.
3. Fill in the rows below with your data, ensuring there are no entirely blank columns interrupting the dataset.
4. Save the Excel file somewhere easily accessible and close Excel. Word cannot access the file if Excel is currently locking it for editing.

Step 2: Set Up the Word Template

1. Open Microsoft Word and create a new blank document, or open an existing letter you wish to use as a template.
2. Navigate to the Mailings tab on the Ribbon at the top of the screen.
3. Click on Start Mail Merge and select the type of document you are creating (e.g., Letters or Email Messages).

Step 3: Connect Word to Your Excel Data

1. Staying on the Mailings tab, click Select Recipients.
2. Choose Use an Existing List from the dropdown menu.
3. A file explorer window will open. Locate and select the Excel spreadsheet you saved in Step 1.
4. A dialogue box will appear asking you to confirm which Sheet contains the data (usually Sheet1). Ensure the box for First row of data contains column headers is ticked, and click OK.

Step 4: Insert Merge Fields into the Document

Now you must tell Word exactly where to place the personalised information.

1. Type the generic text of your letter. For example, type “Dear ” (ensuring you add a space).
2. Keep your cursor positioned after the space. On the Mailings tab, click Insert Merge Field.
3. A dropdown will appear showing the column headers from your Excel sheet. Select First Name.
4. The document will now display «First Name». This is a placeholder.
5. Continue typing your letter and inserting fields wherever needed (e.g., “Your current balance is «Amount Due»“).

Step 5: Preview the Results

Before generating the final documents, you must verify that the data maps correctly.

1. On the Mailings tab, click the Preview Results button.
2. Your placeholders (e.g., «First Name») will transform into the actual data from the first row of your Excel sheet (e.g., “John”).
3. Use the left and right arrow buttons next to the Preview Results button to cycle through a few records and ensure everything looks correct. Pay special attention to spacing and punctuation around the merged fields.

Step 6: Complete the Merge

Once you are satisfied with the preview, you are ready to execute the merge.

1. Click Finish & Merge on the right side of the Mailings tab.
2. You have three options:
   • Edit Individual Documents: This creates a massive new Word document containing every single letter on a new page. This is the safest option, as you can manually review or tweak individual letters before saving or printing.
   • Print Documents: Sends the merged letters directly to your printer.
   • Send Email Messages: If you selected “Email Messages” in Step 2, this will use Microsoft Outlook to automatically email each person their personalised document. (You will need to select the column containing their email addresses).

By mastering Mail Merge, you can eliminate hours of manual data entry, ensuring professional, personalised communication at scale.