Fix the Missing Table Header Error in Word Mail Merge
Question details
The user needs to resolve the “missing table header” error that appears when an Excel workbook is selected as the data source for a label mail merge in Word.

- Product
- Microsoft Word Mail Merge with an Excel workbook data source
- Device & OS
- not provided
- Scenario
- The user is creating a label mail merge and selects an Excel workbook as the data source, but Word cannot identify the table header.
- Observed behavior
- Word reports a missing table header error and the label mail merge cannot proceed until the data source is structured correctly.
Open the Excel workbook and verify that the first worksheet used as the data source contains only one header row with a unique field name in every populated column. Remove any blank header cells, merged cells, decorative title rows, or fully blank data rows before connecting the workbook to the label mail merge.
Prepare the Excel Data Source as a Properly Structured List
Use this solution when the Excel workbook has blank headers, merged cells, title rows, or irregular data that cause the missing table header error.
Word mail merge treats the first row of the selected worksheet, range, or table as the header row. If any header cell is blank, duplicated, merged, or preceded by non-data rows, Word cannot detect a valid table header and stops the label mail merge.
Open the workbook in Excel or WPS Spreadsheets that you want to use as the mail merge data source.
Ensure the first row contains a unique field name in every column you plan to merge, such as FirstName, LastName, Address, City, and PostalCode.
Delete any blank header cells, merged cells, or decorative title rows above the header row.
Make sure each following row contains one complete record, with no fully blank data rows inside the list.
Save the workbook in .xlsx or .xls format and close it before selecting it as the data source in the mail merge.

Select the Correct Worksheet, Range, or Table in the Mail Merge Wizard
Use this solution when the workbook contains multiple sheets, multiple ranges, or a badly selected area so Word opens a headerless or empty range.
Run a Label Mail Merge in WPS Office with a Clean Excel Header Row
In WPS Office, you can complete the same label mail merge with WPS Writer and a WPS Spreadsheets or Excel workbook. Prepare a clean header row once, connect it through the Mailings tab, confirm the first row as column headers, and generate labels without the missing table header error.
- 1. Open WPS Writer and start a label mail merge: Open WPS Writer, go to the Mailings tab, click Mail Merge, and choose Labels.
- 2. Select the cleaned Excel data source: Click Select Recipients > Use an Existing List and choose the cleaned Excel workbook from WPS Spreadsheets or Microsoft Excel.
- 3. Confirm the header row and worksheet: In the mail merge panel, select the worksheet or range that contains the header row, enable “First row of data contains column headers,” and click OK.
- 4. Insert merge fields into the label layout: Add merge fields such as FirstName, LastName, and Address to the first label, then update all labels to mirror the layout.
- 5. Preview and finish the merge: Click Preview Results to verify the records, then click Finish & Merge to create or print the labels.

Frequently Asked Questions
Why does Word say the table header is missing during a label mail merge?
Word expects the first row of the selected Excel data range to contain unique field names. Blank header cells, merged cells, duplicate headers, or title rows above the data prevent Word from detecting a valid table header.
How should I format Excel data for a label mail merge?
Put a unique field name in the first row of every column, avoid blank header cells and merged cells, keep one record per row, and do not leave title rows or empty rows inside the list.
Can WPS Office complete the same label mail merge from an Excel workbook?
Yes. In WPS Writer, go to Mailings > Mail Merge > Labels, select the workbook through Select Recipients > Use an Existing List, confirm the worksheet and the first row as column headers, then insert fields and finish the merge.
Do I need to save and close the Excel workbook before selecting it as a mail merge data source?
Yes. Save and close the workbook before selecting it in the mail merge wizard. This prevents file lock issues and helps the application read the current header row correctly.
Does WPS Office support .xlsx and .docx files for mail merge workflows?
Yes. WPS Office opens and saves Microsoft Excel .xlsx/.xls and Word .docx/.doc files, so you can use the same structured workbook and label document without losing mail merge compatibility.




