Mail Merge Error

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
LVL 4
mvalencia2003Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor 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
0
 
tel2Commented:
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.
0
 
mvalencia2003Author Commented:
Rgonzo1971 ,

How do I change to 97-2003 file
?

or how do I check if this is the issue
?


Thanks
0
 
Rgonzo1971Commented:
97-2003 file are xls not xlsx or xlsm
0
 
mvalencia2003Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.