Solved

Mail Merge Error

Posted on 2014-03-04
5
681 Views
Last Modified: 2014-03-09
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
0
Comment
Question by:mvalencia2003
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 12

Expert Comment

by:tel2
ID: 39905022
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
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39905671
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
 
LVL 4

Author Comment

by:mvalencia2003
ID: 39906175
Rgonzo1971 ,

How do I change to 97-2003 file
?

or how do I check if this is the issue
?


Thanks
0
 
LVL 51

Expert Comment

by:Rgonzo1971
ID: 39906183
97-2003 file are xls not xlsx or xlsm
0
 
LVL 4

Author Closing Comment

by:mvalencia2003
ID: 39916521
Thanks
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

687 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question