Document Editing Problems

How to Combine Word and Excel Data Using Mail Merge

Maira Mehtab Sep 28, 2026 869 views

Question details

The user wants to combine a Word document with an Excel address list utilizing the Mail Merge feature.

Product: Microsoft Word, Microsoft Excel
Device & OS: not provided
Scenario: Generating personalized documents by connecting an external Excel data source to a main Word template.
Observed behavior: The user needs the correct procedure to link Excel data to Word, specifically noting the limitations of web-based applications compared to desktop versions.

Before you start

Ensure that your Excel address list is properly formatted with clear column headers (e.g., First Name, Last Name) in the first row, and verify that the Excel file is completely closed before starting the mail merge process in Word.

Solution 1Recommended

Use the Mail Merge Feature in Desktop Office Applications

Switch from the web versions of Microsoft 365 to the locally installed desktop applications to fully access the Mail Merge tools.

The web-based versions of Microsoft Office applications have limited capabilities and do not fully support the mail merge functionality. To successfully combine your Excel data with a Word document, you must use the locally installed desktop applications provided by your Microsoft 365 Personal or Family subscription.

Install Desktop Applications

If you are currently using the web version, log into your Microsoft 365 account and download the desktop Office applications to your PC or Mac.

Open the Main Document

Launch the desktop version of Microsoft Word and open the document you wish to use as your mail merge template.

Start the Mail Merge

Navigate to the 'Mailings' tab on the top ribbon, click 'Start Mail Merge', and select your preferred document type (such as Letters, Email Messages, or Labels).

Connect the Excel Address List

Click 'Select Recipients' on the Mailings tab, choose 'Use an Existing List', and browse your computer files to select the Excel spreadsheet containing your data.

Application Limitation: Mail merge cannot be completed via the browser. Always ensure you are opening your files directly within the local Microsoft Word desktop application.

Seamless Mail Merge with WPS Office

Easily Combine Documents and Spreadsheets with WPS Office

WPS Office provides a powerful, free, and intuitive Mail Merge feature that seamlessly connects WPS Writer documents with WPS Spreadsheet data. It is an excellent lightweight alternative that runs locally on your computer, bypassing the limitations of web-only editors.

1. Open Your Template in WPS Writer: Launch WPS Writer and open the document you want to use for your mail merge.
2. Access Mail Merge Tools: Navigate to the 'References' tab on the top menu and click on the 'Mail Merge' button to reveal the dedicated mail merge ribbon.
3. Open the Data Source: Click 'Open Data Source', browse your local files, and select your Excel (.xlsx) or WPS Spreadsheet file containing the address list.
4. Insert Merge Fields: Place your cursor in the document where the data should appear, click 'Insert Merge Field', and choose the relevant column headers.
5. Merge to Document: Click 'Merge to New Document' to generate a new file containing all your personalized pages based on the spreadsheet data.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsLightweight desktop application that runs smoothly without high system requirementsFree and intuitive Mail Merge functionality built directly into WPS WriterAll-in-one suite to manage documents, spreadsheets, and PDFs in a single window

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Mail Merge option missing or grayed out in Word?

If you are using the web version of Microsoft Word, the Mail Merge feature is highly limited or unavailable. You must install and open the desktop application of Microsoft Word to access the full Mailings ribbon.

How should I format my Excel list for a successful mail merge?

Your Excel spreadsheet should have clear column headers (like First Name, Last Name, Email) in the very first row. Ensure there are no blank rows or merged cells at the top, and close the Excel file before initiating the merge in Word.

Can I preview my mail merge documents before printing?

Yes. After connecting your data source and inserting the merge fields, go to the 'Mailings' tab and click 'Preview Results'. You can then use the arrow buttons to cycle through your records to verify everything is formatted correctly.

Is it possible to use Mail Merge to send personalized emails?

Yes. When setting up the mail merge in the desktop app, select 'Email Messages' as your document type. You will need a column in your Excel data that contains the recipient email addresses and a locally configured email client like Outlook to send them.

Document & File Issues