Why Does Word Mail Merge Show an Excel Table with a Dollar Sign?
Question details
The user is confused about seeing an extra Excel table name ending with a dollar sign (e.g., Addresses$) when setting up a mail merge in Word, even when no such worksheet exists in the Excel file.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Setting up an Excel data source for a Word mail merge document.
- Observed behavior
- The "Select Table" dialog and SQL prompts display worksheet names with an appended dollar sign, appearing as if a new table was created.
Before proceeding, ensure your Excel data source workbook is saved, closed, and contains clearly labeled column headers in the first row to guarantee a smooth connection.
Understand the Dollar Sign Notation and Proceed with the Merge
The dollar sign is a standard SQL reference symbol used by Word to identify Excel worksheets, not an indication of a duplicate sheet.
When you connect an Excel workbook to a Word mail merge document, Word uses OLE DB to read the data. In this background process, Excel worksheets are treated as database tables, and the system automatically appends a dollar sign ($) to the end of the sheet name (e.g., Addresses$).
This does not mean a new worksheet was created or duplicated in your file. It is completely normal behavior and you should select this table to access your data.
In your Word document, go to the 'Mailings' tab, click 'Select Recipients', and choose 'Use an Existing List'.
Browse your computer to find your saved Excel workbook containing your contact list, select it, and click 'Open'.
When the 'Select Table' dialog appears, select the entry that matches your sheet name followed by a dollar sign (e.g., 'Sheet1$' or 'Addresses$').
Ensure the 'First row of data contains column headers' checkbox is ticked if your Excel sheet has headers, then click 'OK' to finalize the connection.
Use WPS Writer for Seamless Mail Merge Tasks
WPS Office provides a highly compatible and user-friendly Mail Merge feature. You can easily connect WPS Spreadsheets to your WPS Writer documents without dealing with confusing database queries or complex SQL prompt notations.
- 1. Prepare your Data: Open WPS Spreadsheets, organize your data with clear headers in the first row, and save the .xlsx file.
- 2. Start Mail Merge in WPS Writer: Open your document in WPS Writer, navigate to the 'References' tab, and click on 'Mail Merge'.
- 3. Open Data Source: Click 'Open Data Source', locate your saved spreadsheet, and simply choose the correct sheet from the straightforward prompt.
- 4. Insert Fields and Merge: Click 'Insert Merge Field' to place your data into the document, then click 'Merge to New Document' to generate your letters.
Frequently Asked Questions
Why do I see a _FilterDatabase table along with the dollar sign table?
This occurs if you have previously applied sorting, filtering, or print areas to your data in Excel. Word recognizes this filtered view as a separate named range. You should usually select the main sheet name ending in just the dollar sign (e.g., Sheet1$) to access your entire, unfiltered list.
Can I rename the table to remove the dollar sign in Word?
No, the dollar sign is automatically generated by Word's OLE DB background connection to properly identify the Excel worksheet as an active database table. You cannot remove or rename it within the Select Table dialog.
What if my Word mail merge is missing records after selecting the table?
First, ensure you selected the correct table ending in a dollar sign. If records are still missing, check your original Excel file to ensure there are no entirely blank rows interrupting the data range, and verify that all data was saved before you connected the file to Word.
