View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merge Recipeints List - External table is not in expected format

As a workaround you can try exporting the data from Excel to .csv format
or Edit-Copy, Edit-Paste to a new Word document and use that as the
data source.

Otherwise,
a. which version of Word/Excel?
b. the most likely reason for this error is that the file is not
actually an Excel workbook, but has a .xls extension. For example, it
might be an HTML table with a file extension of .xls instead of .htm or
..html - particularly if the file has been exported from someone else's
system.

Peter Jamieson

http://tips.pjmsn.me.uk

Arnprior wrote:
I have an excel file I'm trying to use in a merge in Word. This error appears??