Solved: Word Merge Connection to Excel failing

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

techexpressinc2

Thread Starter
Joined
Jan 21, 2011
Messages
3
In mail merge, when I attempt to select the excel file, it brings up a window
called "Data Link Properties." When I click "test connection" it gives themessage "Test
connection failed because of an error in initializing provider. Catastrophic
failure." This causes word to shut down.

Any ideas on a fix appreaciated.. Thx Russ - Russell.Neuman @ lfg.com
 

Attachments

jimr381

Jim
Joined
Jul 20, 2007
Messages
4,193
Welcome to the forum.

Open the Word document up and have it ignore the connection. Then reconnect to the Excel spreadsheet via the data source option and then you should be fine.
 

techexpressinc2

Thread Starter
Joined
Jan 21, 2011
Messages
3
Solved, the process used is this:
1) Open MS-Word
2) Click Tools menu
3) Click Options menu
4) Click General tab

5) Click so there is a check mark in the box “Confirm conversion at open”
6) Close MS-Word
7) Then when doing the merge selection select .xls as type
Thx
Rus
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top