File Format & Compatibility

How to Allow Word to Open an Excel File for Mail Merge

Huma Ashraf Ch Oct 7, 2026 868 views

Question details

The user needs to authorize Word to access an Excel workbook to successfully use it as a data source for a mail merge.

How to Allow Word to Open an Excel File for Mail Merge

Product: Microsoft Word
Device & OS: macOS
Scenario: Setting up a mail merge (such as creating address labels) using an Excel workbook as the data source.
Observed behavior: Word displays a macOS security or converter prompt asking for permission to access and read the Excel file type.

Before you start

Ensure your Excel workbook is fully saved and closed before attempting to link it as a data source in Word to prevent file locking issues.

Solution 1Recommended

Grant File Access to the Office Converter

Authorize Word to use the built-in Office converter to read your Excel data source on macOS.

On macOS, cross-application data sharing requires explicit user permission due to system sandboxing rules. The converter is an integrated and safe Microsoft Office component specifically designed to allow Word to interpret Excel spreadsheet data.

Start the mail merge

Open your Word document, navigate to the Mailings tab, click Select Recipients, and choose Use an Existing List to locate your Excel file.

Acknowledge the macOS prompt

When a dialog box appears asking if Word may access the Excel file or use the converter, recognize this as a standard security check.

Grant access

Click 'Yes' or 'Allow' to grant the necessary permissions. Word will securely process the file and link the data.

Continue the merge

Proceed with inserting your merge fields and finalizing your mail merge document or labels.

Grant File Access to the Office Converter

Permission Saved: Once you grant this permission for a specific folder or file, macOS typically remembers your choice, minimizing repeated prompts in future sessions.

Integrated Mail Merge Tool

Perform Mail Merges Easily with WPS Office

WPS Office provides a highly compatible and integrated Mail Merge feature. You can easily use WPS Spreadsheets as a data source for WPS Writer documents without encountering persistent cross-app security prompts.

1. Open your document in WPS Writer: Launch WPS Writer and open your main document template where the mail merge will be performed.
2. Access the Mail Merge tab: Navigate to the 'References' tab and click on the 'Mail Merge' button to reveal the dedicated tool ribbon.
3. Link your data source: Click 'Open Data Source' and select your .xlsx spreadsheet containing the contact list or merge data.
4. Insert merge fields: Use the 'Insert Merge Field' button to place your data variables exactly where you need them in the document.
5. Generate the final documents: Click 'Merge to New Document' or 'Merge to Printer' to complete the process and output your merged files.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Built-in Mail Merge tool handles address labels, letters, and emails smoothly.Lightweight suite with seamless data sharing between Writer and Spreadsheets.Free to download with an intuitive, familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word need a converter to open an Excel file?

Word uses a specialized, integrated converter component to translate the structured, tabular data in an Excel workbook into a readable database format that the mail merge tool can process.

What happens if I click 'No' on the macOS security prompt?

If you deny access, Word will be blocked from reading the Excel file, causing the mail merge setup to fail. You will need to restart the recipient selection process and click 'Yes' to proceed.

Why is my Excel data not updating in the Word mail merge?

If you modify the Excel file while the Word document is actively linked, the changes might not reflect immediately. Save and close the Excel file, then refresh the data source in Word or re-select the recipient list.

Does this prompt mean my Excel file is unsafe?

No. The prompt is a standard macOS privacy feature (sandboxing) ensuring that applications only access files you explicitly authorize. It is completely safe to grant access to files you created or trust.

Document & File Issues