data file location problem

[Robin]

I recently ran a large mail merge (Excel data into Word) which crashed my
system. Ever since, I can't run mail merge from Excel files. When I
designate an Excel file as the data source, I consistently get a message
that says "cannot find file (or one of its components). Make sure the path
and filename are correct and that all required libraries are available."

I can, however, open these same data files directly within Excel. I've run
Norton Utilities and have reinstalled Office, but still no fix. Any
suggestions (short of reinstalling the operating system)?

 

[Cindy Meister -WordMVP-]

Hi Robin,

Let's start with the version of Office we're dealing with. Then, did you
explicitly choose a particular type of connection method? And can you
double-click an Excel file in Windows Explorer and have it open with no
problems in Excel?

I recently ran a large mail merge (Excel data into Word) which crashed my
system. Ever since, I can't run mail merge from Excel files. When I
designate an Excel file as the data source, I consistently get a message
that says "cannot find file (or one of its components). Make sure the path
and filename are correct and that all required libraries are available."

I can, however, open these same data files directly within Excel. I've run
Norton Utilities and have reinstalled Office, but still no fix. Any
suggestions (short of reinstalling the operating system)?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Robin]

Hi Cindy,

I'm using Office 2000. I did not choose a particular connection method.
And no, when I double-click on an Excel file in Windows Explorer I get the
same error message.

Thanks,
Robin