Solved

Mail Merge Error

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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lookup range formula 7 25
Excel Date Question 8 41
Excel Auto-Complete lines 4 30
date format is changing when i run the macro 3 15
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

738 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