How to Use Copilot in Word for Mail Merge With Excel Data Sources

You want to create personalized letters, envelopes, or email messages for a large list of recipients without typing each one manually. Word’s mail merge feature combined with Copilot can automate this process by pulling data directly from an Excel spreadsheet. This article explains how to set up the data source, write a template in Word, and use Copilot to generate the merged output. You will learn the exact steps to connect Excel columns to Word fields and produce finished documents in minutes.

What Copilot in Word Does for Mail Merge

Mail merge in Word traditionally requires you to manually select a data source, insert merge fields, and run the merge process. Copilot simplifies this workflow by automating the data source connection and field insertion steps. When you open a document and activate the Copilot pane, it can scan your Excel file and suggest the correct columns for common merge fields like Name, Address, and City.

Before you start, confirm the following prerequisites are in place:

• You have a Microsoft 365 subscription that includes Copilot for Microsoft 365. The Copilot feature is not available in Office 2019 or Office 2021.
• Your Excel workbook is saved in a SharePoint or OneDrive for work or school location. Copilot cannot read local files or files stored on a network drive.
• The Excel data is formatted as a table with column headers in the first row. Each row represents one recipient. No blank rows or columns exist inside the data range.
• Your Word document is open and you have the Copilot pane visible. If the pane is not open, click the Copilot icon on the Home tab or press Alt+Shift+C.

Copilot does not replace the entire mail merge engine. It assists with the setup and field mapping stages. You still use the standard Mailings tab to preview results and finish the merge.

Steps to Set Up Copilot for Mail Merge with Excel Data

Follow these steps to connect Excel data to a Word document and use Copilot to insert merge fields.

1. Prepare the Excel data source
   Open your Excel workbook. Select the range that contains your recipient list. On the Insert tab, click Table. Confirm the My table has headers checkbox is selected. This creates a named table that Copilot can identify. Save the file to SharePoint or OneDrive for work or school.
2. Open Word and start the mail merge
   In Word, create a new blank document or open an existing template. On the Mailings tab, click Start Mail Merge and choose the document type: Letters, E-mail Messages, Envelopes, or Labels. The Copilot pane will remain active during this process.
3. Select the Excel data source with Copilot
   In the Copilot pane, type a prompt such as: “Connect to my Excel file named CustomerList.xlsx and prepare the mail merge.” Copilot will ask you to confirm the file location. Click Browse to navigate to the SharePoint or OneDrive folder where the Excel file is stored. Select the file and click Open. Copilot will display the table name and column headers from your Excel sheet.
4. Insert merge fields using Copilot suggestions
   Place your cursor in the Word document where you want the first merge field to appear. In the Copilot pane, you will see a list of suggested fields based on your Excel headers. For example, if your Excel columns are First Name, Last Name, Address, City, and Zip, Copilot will show these as clickable options. Click the field name to insert it into the document. Repeat for each field location. Copilot inserts the field using the standard MERGEFIELD format.
5. Preview the merged data
   On the Mailings tab, click Preview Results. Word will replace the merge fields with actual data from the first row of your Excel table. Use the navigation arrows to scroll through records. If the data looks correct, proceed to the next step. If fields are missing or misaligned, return to the document and adjust the field positions manually.
6. Complete the merge
   On the Mailings tab, click Finish & Merge. Choose Edit Individual Documents to generate a new Word file with one page per recipient. Choose Print Documents to send the merged output directly to a printer. Choose Send E-mail Messages if you are creating personalized emails. Copilot will confirm the operation before executing it.

Common Mistakes and How to Avoid Them

Copilot cannot find the Excel file

If Copilot reports that the file is not accessible, verify the file is saved in a SharePoint or OneDrive for work or school library. Local drives, USB drives, and personal OneDrive accounts are not supported. Also confirm that you have at least read permissions to the file. If the file is shared with you, open it in Excel online once to ensure the sync is active.

Merge fields show as plain text instead of data

This occurs when the Excel table is not formatted as a named table. Copilot and Word rely on the table name to map fields. Select the data range in Excel, press Ctrl+T, and confirm the table name. Save the file and reconnect it in Word using the Select Recipients button on the Mailings tab. Copilot will then recognize the fields correctly.

Copilot inserts the wrong field name

If the Excel column headers contain spaces or special characters, Copilot may misread them. Rename the columns to single words without spaces, such as FirstName instead of First Name. After saving the Excel file, refresh the data connection in Word by clicking Edit Recipient List on the Mailings tab and confirming the field list.

Merge produces blank pages or duplicate records

Blank pages usually appear when the Word document contains extra paragraph marks at the end of the template. Delete any empty paragraphs after the last merge field. Duplicate records indicate that the Excel table contains blank rows. Remove all blank rows from the table and refresh the data source in Word.

Item	Manual Mail Merge	Copilot-Assisted Mail Merge
Data source connection	Use Select Recipients on Mailings tab	Copilot pane prompt to connect file
Field insertion	Click Insert Merge Field and pick from list	Copilot suggests fields from Excel headers
Error handling	Manual troubleshooting of field names	Copilot flags mismatched headers
Preview	Click Preview Results on Mailings tab	Same Preview Results button used
Output generation	Finish & Merge options identical	Copilot confirms before merging

Copilot reduces the time spent on field mapping and data source selection. The final merge steps remain unchanged from the standard Word workflow.

You can now connect an Excel table to a Word document and use Copilot to insert the correct merge fields automatically. The Copilot pane handles the field suggestions and data source verification steps. For advanced scenarios, try using Copilot to generate conditional merge rules, such as inserting different greeting lines based on a Gender column. This feature is available only in Copilot for Microsoft 365 licenses.