Fix Blank Select Table Window in Word Mail Merge (Excel Source)
Question details
The user is unable to select a table during a Word mail merge because the Select Table dialog box appears completely blank when attempting to connect an Excel data source.
- Product
- Microsoft Word 365, Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Attempting to link an Excel spreadsheet to a Word document to act as a data list for a Mail Merge operation.
- Observed behavior
- The second Select Table window appears entirely blank, preventing the user from selecting the required Excel worksheet, regardless of the file location, workbook, or document used.
Ensure that both your Word document and Excel data source are fully closed before making administrative changes to the file names or worksheet structures.
Remove Apostrophes and Special Characters from the Worksheet Name
The most common cause of a blank Select Table window is an unsupported special character, particularly an apostrophe, in the Excel sheet name. Renaming the sheet resolves the conflict.
Microsoft Word's Mail Merge feature can struggle to parse Excel worksheet names that contain specific punctuation marks. An apostrophe (') in the tab name breaks the backend SQL query Word uses to pull the table list, resulting in a completely blank selection window.
Launch Microsoft Excel and open the workbook that contains your mailing list data.
Look at the bottom of the Excel application window to find the worksheet tab containing your targeted data.
Right-click the worksheet tab and select 'Rename'. Carefully remove any apostrophes (') or other special symbols from the name, replacing them with standard letters or numbers.
Save the Excel workbook and close the application. Open your Word document and restart the Mail Merge recipient selection process to view the successfully restored table list.
Easily Perform Mail Merges with WPS Writer
WPS Office provides a highly compatible, intuitive Mail Merge feature that seamlessly integrates with your existing Excel (.xlsx) data sources, completely avoiding common software glitches and synchronization issues.
- 1. Open WPS Writer: Create a new document or open your existing letter template in WPS Writer.
- 2. Access the Mailings Tab: Navigate to the 'Mailings' tab on the top ribbon and click on 'Mail Merge' to activate the tools.
- 3. Select Data Source: Click 'Open Data Source', locate your Excel spreadsheet on your computer, and seamlessly select your worksheet.
- 4. Insert Fields and Merge: Click 'Insert Merge Field' to place your variables into the document, then click 'Merge to New Document' to finish your project.
Frequently Asked Questions
Why does Word Mail Merge not recognize my Excel spreadsheet?
This usually happens if the Excel file is currently open and locked by another application, if the worksheet contains special characters like apostrophes in its name, or if the data doesn't start in the first cell (A1) of the sheet.
Can I use multiple worksheets for a single Mail Merge?
Word Mail Merge can only connect to one worksheet or named range at a time. If your data spans multiple sheets, you must consolidate it into a single master worksheet before starting the merge process.
What are the best practices for formatting Excel data for Mail Merge?
Ensure your first row contains clear, unique column headers with no blank rows or columns separating the data. Avoid using complex formatting, merged cells, or special characters in the worksheet tab names to ensure a smooth connection.
