mailmerge error message office


starstarstarstarstar Excellent

Forum home » Delegate support and help forum » Microsoft Office general help » Mail-merge error message in Office (Word) 2010

Mail-merge error message in Office (Word) 2010

resolvedResolved · High Priority · Version 2010

Fri 2 Nov 2012, 09:00 replyReply Delegate Suvira said...

Suvira has attended:
Access Intermediate course
Access Advanced course

Mail-merge error message in Office (Word) 2010

When mail-merging a form letter with an Excel datasource, this message comes up:
"Error has occurred: External Table is not in the expected format"

For upcoming training course dates see: Pricing & availability

Fri 2 Nov 2012, 16:01 replyReply Trainer Andrew said...

RE: Mail-merge error message in Office (Word) 2010

Hi Suvira

Thank you for your question. I'm sorry to hear you are running into problems. Can you let me know a little more about the Excel file you are connecting to?

Is the Excel document password protected?
How do you connect to the data source. Do you point Word to the file itself or to a DDE data connection? (which has already been set up to connect to the Excel file)

Let me know and I will do my best to help.

Kind regards,

Wed 14 Nov 2012, 15:06 replyReply Delegate Suvira said...

RE: Mail-merge error message in Office (Word) 2010

Dear Andrew

The Excel file is not password protected. It is saved as an .xlsx document.

I have found a solution - that is by saving this data source to a previous version .xls (2003 /2007) file format (instead of the more recent .xlsx format. This make the file useable and it is possible to link with the mail merge form letter. However, I do not understand why.

Creating a data source in Word 10 has not caused any problems, so I can't understand the reason for it not working with an Excel file. If you have a plausable explaination, it will be very useful knowing.

Thank you

Fri 16 Nov 2012, 11:07 replyReply Trainer Simon said...

RE: Mail-merge error message in Office (Word) 2010

Hi Suvira,

I am currently in the process of trying to sort out all the active questions on the support forum.

The only thing I can think of, is that it might be something to do with the new xml coding.

Sorry I couldn't have been of more help.



Fri 16 Nov 2012, 11:07 replyReply Trainer Simon said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 23 Nov 2012: Automatically marked as resolved.


Microsoft office tip:


Instead of closing or savng all your files one by one, you can do this in one step by holding the SHIFT key whilst clicking on the FILE menu.

You will then see a Close All and Save All option in the menu

View all Microsoft Office hints and tips


Live dates & prices


Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.