1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Word Merge Connection to Excel failing

Discussion in 'Business Applications' started by techexpressinc2, Jan 21, 2011.

Thread Status:
Not open for further replies.
  1. techexpressinc2

    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
     

    Attached Files:

  2. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    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.
     
  3. techexpressinc2

    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
     
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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/976034

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice