'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Word Mail Merge Cannot Open Data Source Error on Mac
Question details
The user is experiencing a "Cannot open data source" error when attempting to perform a mail merge in Microsoft Word for Mac using an Excel spreadsheet.
- Product
- Microsoft Word
- Device & OS
- macOS
- Scenario
- Attempting to link an Excel workbook as a data source for a mail merge document.
- Observed behavior
- Microsoft Word throws an "Error! Cannot open data source" message and fails to connect to or read the linked Excel file.
Make sure both your Word document and your Excel data source file are saved locally on your Mac (e.g., in your Documents folder) rather than on a cloud drive to prevent syncing or path access conflicts during the merge.
Save the Excel Data Source as a CSV File
Bypasses Mac-specific Excel connectivity issues by using a universally readable text format for the data source.
On macOS, Word sometimes struggles to communicate securely with Excel due to sandboxing restrictions. Converting your data source to a Comma Separated Values (CSV) file removes complex formatting and allows Word to read the data directly without needing to interface with the Excel application.
Launch Microsoft Excel and open the workbook you are trying to use for your mail merge.
Click on 'File' > 'Save As' from the top menu bar. In the 'File Format' dropdown menu, select 'CSV UTF-8 (Comma-delimited) (.csv)' and save it to the same folder as your Word document.
Open your Word document, go to the 'Mailings' tab, click 'Select Recipients', and choose 'Use an Existing List'. Locate and select your newly created CSV file.
Use an Absolute File Path in the DATABASE Field
Corrects relative path confusion that often causes Word for Mac to lose track of the data source location.
Remove Excel File Protections
Ensures Word is not blocked by read-only or password restrictions on the Excel file.
Effortlessly Perform Mail Merge with WPS Office for Mac
Avoid complex DATABASE field errors and file path issues by using WPS Office. Its built-in Mail Merge feature seamlessly connects with spreadsheets, offering a smooth and intuitive experience for Mac users without the hassle of syntax errors.
- 1. Open Your Document in WPS Writer: Launch WPS Office on your Mac, open your letter or template in WPS Writer, and navigate to the 'Mailings' tab on the ribbon.
- 2. Connect Your Spreadsheet: Click 'Open Data Source' and select your Excel (.xlsx) or CSV file. WPS Office connects to it natively without triggering database access errors.
- 3. Insert Merge Fields: Use the 'Insert Merge Field' button to easily place your column headers (like Name or Address) exactly where you want them in the document.
- 4. Complete the Merge: Click 'Merge to New Document' or 'Merge to Printer' to quickly generate your personalized batch of documents.
Frequently Asked Questions
Why does Word for Mac struggle with Excel data sources during mail merge?
Word for Mac operates under Apple's sandboxing rules, which restricts how applications communicate with each other. Sometimes the specific OLE DB drivers fail to securely bridge the connection between Word and Excel, resulting in the 'Cannot open data source' error.
Can I use Apple Numbers instead of Excel for a Word mail merge?
No, Microsoft Word cannot directly read Apple Numbers (.numbers) files as a data source. You must first open your spreadsheet in Numbers, select 'File' > 'Export To', and choose either 'Excel' or 'CSV' before importing it into Word.
What does the DATABASE field code look like for a CSV on a Mac?
A standard CSV field code on Mac looks similar to: {DATABASE \d "path/to/YourData.csv" \l "15" \b "49" \h}. You can view and edit these underlying codes in your document by pressing Option+F9.
