mailmerge error message office
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777
STL

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,
Andrew

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
Sue

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.

Regards

Simon

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:

CLOSE and SAVE ALL

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

Training classes
London & UK

Live dates & prices »

On-site training

60-second quote »

E-Learning

From £99 · Call us »

Mailing list

Sign up for latest offers »

 

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.


Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom

info@microsofttraining.net

Resources

X

Search