'%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 Use a Shared or Online Excel File for Word Mail Merge
Question details
The user needs to use a shared Excel workbook or an online document link as the data source for a Word mail merge but cannot connect directly via the web link.
- Product
- Microsoft Word, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to generate bulk documents or labels in Word using data hosted in an online or shared cloud Excel file.
- Observed behavior
- Pasting the online document link into the data source selection field fails. Word does not recognize web URLs as valid database connections for mail merge.
Ensure your Excel data is properly formatted by placing clear column headers (e.g., First Name, Last Name) in the very first row, leaving no blank rows or columns before the actual data begins.
Download a Local Copy of the Shared Excel File
Since Word mail merge cannot directly read web URLs, downloading the file to your computer provides the local path that Word requires.
Mail merge uses OLE DB protocols which rely on local file paths or mapped network drives. By saving a local copy of your cloud file, you bypass the URL restriction and allow Word to read the data correctly.
Open your shared Excel file in the web browser. Go to File > Save As, and click 'Download a Copy' to save the file to your local Downloads or Documents folder.
Open your Microsoft Word document. Navigate to the Mailings tab on the ribbon, click 'Select Recipients', and choose 'Use an Existing List...' from the drop-down menu.
In the file explorer window that appears, locate and select the Excel file you just downloaded. Click 'Open', select the specific sheet containing your data, and click 'OK'.
Use OneDrive or SharePoint Desktop Sync for Live Data
If you need the Word mail merge to reflect live data updates made by other users, use desktop folder synchronization rather than a static download.
Perform Mail Merges Seamlessly with WPS Office
WPS Office features a robust, built-in Mail Merge tool that natively reads local and synced spreadsheets. Easily create bulk letters, envelopes, and labels without dealing with complex cloud connection errors.
- 1. Open WPS Writer: Launch WPS Office and open a new or existing document where you want to place the merged data.
- 2. Access the Mail Merge Tool: Navigate to the 'References' tab on the top ribbon and click the 'Mail Merge' button to display the mail merge toolbar.
- 3. Open Your Data Source: Click 'Open Data Source' and select your locally saved or synced WPS Spreadsheet or Excel file.
- 4. Insert Merge Fields: Place your cursor in the document, click 'Insert Merge Field', and select the corresponding data columns from your spreadsheet.
- 5. Finish the Merge: Click 'Merge to New Document' or 'Merge to Printer' to instantly generate your bulk personalized documents.
Frequently Asked Questions
Why can't I just paste an online Excel link into Word's data source field?
Word's Mail Merge engine relies on OLE DB or ODBC database connection protocols, which require a valid local file path or a recognized mapped network drive. Web URLs (like a browser link to a cloud file) are not supported by these connection protocols.
How do I fix the 'file in use' error during a shared Excel mail merge?
This error happens when another user has the shared Excel file open for editing. Ask all collaborators to save and close the file, or create an offline copy of the spreadsheet specifically for running the mail merge.
Can I use Google Sheets as a data source for a Word mail merge?
Not directly through a web link. You must first open the Google Sheet, go to File > Download > Microsoft Excel (.xlsx), and save the file locally. You can then select that downloaded file as your data source in Word.
What formats can I use for a Mail Merge data source?
Supported data sources include Microsoft Excel workbooks (.xlsx, .xls), CSV files, text files, Microsoft Access databases, and even other Word documents that contain properly formatted tables.
