Mail Merge Error

mvalencia2003
mvalencia2003 used Ask the Experts™
on
I try to do a mail merge to a word document , from excel file - getting error :

Error has occurred: External table is not in the expected format.


Have Office 2010 ,
Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hard to help you without having both files.  If they contain sensitive data, change them so they don't.  Just a few records should be enough, but test with those few records first, to make sure you still get the error, and if you do, post them here.
Top Expert 2016
Commented:
Hi,

it could be that the Mailmerge is waiting for an Excel 97-2003 and you are giving an Excel 2007-2010 file

Regards

Author

Commented:
Rgonzo1971 ,

How do I change to 97-2003 file
?

or how do I check if this is the issue
?


Thanks
Top Expert 2016

Commented:
97-2003 file are xls not xlsx or xlsm

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial