How to Fix Excel Table Names and Data Sources in Word Mail Merge
Question details
The user is experiencing an issue where Word Mail Merge selects the incorrect Excel sheet or data source after an Excel table is converted to a range, and also needs to filter the records to include only specific rows.
- Product
- Microsoft Word / Excel
- Device & OS
- not provided
- Scenario
- Performing a Mail Merge in Word using an Excel spreadsheet as the data source.
- Observed behavior
- Word continues to use the old Excel table name or incorrect sheet, and the user needs to exclude certain rows (like records without a Start Date) from the mail merge.
Ensure your Excel workbook is saved and completely closed before attempting to re-link or change the data source in Word, as an open file can sometimes cause read errors or lock the data connection.
Manually Re-select the Excel Data Source in Word
Manually updating the data source forces Word to drop the old cached table name and connect to the updated Excel range or sheet.
When you convert an Excel table to a standard range, Word may still look for the old table name. Because table names and defined names operate differently in Excel, you cannot always clear them from the Name Manager. Re-establishing the connection is the most reliable fix.
Launch Word and open the document you are currently using for the mail merge.
Go to the 'Mailings' tab located on the top ribbon.
Click on 'Select Recipients' and choose 'Use an Existing List' from the drop-down menu.
Browse your computer to locate your Excel file, open it, and explicitly select the correct worksheet or newly defined range containing your updated data.
Create a Filtered Helper Table in Excel
Use this method if you only want to merge specific records, such as those with a valid Start Date, without relying on complex rules in Word.
Perform Mail Merge Seamlessly with WPS Office
WPS Office provides a highly compatible and intuitive Mail Merge feature. You can easily link WPS Spreadsheets to WPS Writer documents to generate bulk letters, labels, or emails without data source conflicts.
- 1. Open WPS Writer: Launch WPS Writer and navigate to the 'Mailings' tab on the main ribbon.
- 2. Open Data Source: Click 'Open Data Source' and select the WPS Spreadsheet file that contains your recipient list.
- 3. Insert Merge Fields: Place your cursor where you want the data to appear, then click 'Insert Merge Field' to add the relevant columns from your spreadsheet.
- 4. Complete the Merge: Click 'Merge to New Document', 'Merge to Printer', or 'Merge to Email' to finalize your bulk task.
Frequently Asked Questions
Why can't I delete an Excel table name from the Name Manager?
Excel manages Table names dynamically. To remove a table name, you must click inside the table, go to the Table Design tab, and select 'Convert to Range'. Standard defined names can be deleted in the Name Manager, but Table names are strictly tied to the Table object itself.
How can I filter out blank dates during a Word Mail Merge?
Instead of writing complex IF statements in Word, you can click 'Edit Recipient List' in the Mailings tab to manually uncheck blank records. Alternatively, the easiest approach is to pre-filter your Excel data and copy the valid rows into a separate 'helper' sheet before merging.
Why does Word keep selecting the wrong sheet during a mail merge?
Word caches the connection properties of your previous data source. If you modify the Excel file structure, such as changing a table to a range, you must manually refresh the connection. Go to 'Select Recipients' > 'Use an Existing List' and select the file again to update the configuration.
