?
Solved

Mail Merge Error

Posted on 2014-03-04
5
Medium Priority
?
1,083 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
  • 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 54

Accepted Solution

by:
Rgonzo1971 earned 2000 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 54

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

840 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