View Single Post
  #1   Report Post  
Dave
 
Posts: n/a
Default Mail merge error occurs when filtering Excel data source

A customer is using an Excel 2000 workbook with approximately 5600 records,
to perform mail merges to letters and labels in Word 2000.

The customer is attempting to filter the data using the merge helper and
create a merge based on a specific city and state. When the merge is
initiated, the following error message appears;

€śWord could not merge the main document with the data source because the
data records were empty or no data records matched your query options.€ť

I have reviewed the Excel workbook data and cannot see a problem with the
fields or records that would prevent the merge. In addition, we have
completely uninstalled and reinstalled Office 2000 believing that there was
the possibility Word was not extracting the data correctly from Excel.

If anyone has any suggestions or a resolution, I would appreciate the input.