Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2005

Tip: Looking for answers? Try searching our database.

Finding the path

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
abrown - 28 Jul 2005 16:51 GMT
I have a user in a department who has somehow deleted or renamed their mail
merge datasource (csv) and Word is throwing the usual "can't find" error,
only the path is truncated (ie "c:\dir1\dir2\.....\filename.csv").

Is there any way of identifying the full path, perhaps with VBA?
Peter Jamieson - 28 Jul 2005 18:56 GMT
As you've probably realised, you can't open the document without making a
connection or removing the connection, so
a. you'll probably only be able to see the existing connection details if
the original mail merge main document was saved in .rtf, .html or .xml
format, in which case you could try opening the document as a plain text
file, eiither in Word or e.g. Notepad and have a look for the data source
name in there
b. is there any artefact of the deleted file in Windows - e.g. could it be
in the recycle bin? If it has been renamed, would a search for files with
recent modification dates help?

Maybe a file recovery utility would also be useful...

Peter Jamieson

>I have a user in a department who has somehow deleted or renamed their mail
> merge datasource (csv) and Word is throwing the usual "can't find" error,
> only the path is truncated (ie "c:\dir1\dir2\.....\filename.csv").
>
> Is there any way of identifying the full path, perhaps with VBA?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.