Solved

Mail Merge Error

Posted on 2014-03-04
5
533 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 11

Expert Comment

by:tel2
Comment Utility
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 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
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
Comment Utility
Rgonzo1971 ,

How do I change to 97-2003 file
?

or how do I check if this is the issue
?


Thanks
0
 
LVL 48

Expert Comment

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

Author Closing Comment

by:mvalencia2003
Comment Utility
Thanks
0

Featured Post

A Knowledge Base That Stays Up-to-Date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
My experience with Windows 10 over a one year period and suggestions for smooth operation
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now