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 / May 2004

Tip: Looking for answers? Try searching our database.

Data Source Not Found

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandra - 07 May 2004 20:45 GMT
I'm using Word 2002. I'm using a mail merge file. I have
moved my data file (an excel file)to another directory.  
Now when I open the document file in Word, it gives me
the message, "file not found."  I find the file, then
save the Word file, hoping it will also save the
information of which data file I'm using. But it does
not. The next time I open the Word file, I have to find
the data file again.  This also occurs if I
choose "Options" and "Remove Data/Header source".  After
I get the data file again, save the Word file, close and
reopen, I have to do it ALL OVER AGAIN!   Surely there is
a way.
Doug Robbins - Word MVP - 07 May 2004 23:46 GMT
Fellow MVP Cindy Meister posted this in response to another post about a
similar problem:

Quote

I'd try:
   - create a new document
   - copy all but the last paragraph mark of an existing
main merge doc to the new doc
   - link back up to the datasource (Outlook contacts)
   - merge
   - save, close, re-open

If this works, then this is what you'll have to do for each
main merge document. Note that you'll need to watch out for
things like margins, headers, footers...

Unquote

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I'm using Word 2002. I'm using a mail merge file. I have
> moved my data file (an excel file)to another directory.
[quoted text clipped - 8 lines]
> reopen, I have to do it ALL OVER AGAIN!   Surely there is
> a way.
Azi - 12 May 2004 17:51 GMT
Yes, that reply was posted to a similar problem I had. The problem is the workaround, while greatly appreciated, doesn't work. there must be a way to prevent that temp file (as described in KB article 275934) from being deleted or at least a way to change the path statement. I'm not a developer, so Word path statements are foreign to me. If anyone finds a good work around, please post it.
Doug Robbins - Word MVP - 13 May 2004 00:09 GMT
Try this:

From the View menu, select Toolbars and then turn on the mailmerge toolbar.

With the mailmerge main document, active, click on the leftmost button on
the mailmerge toolbar and select "Normal Word Document", Save the Document,
then click on the second toolbar button (Open Data Source) and navigate to
the new location of the data source and open it.  Now save the document and
then close it and re-open it and see if the data source remains attached.

Please post back with the result so that we will know if this works.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Yes, that reply was posted to a similar problem I had. The problem is the workaround, while greatly appreciated, doesn't work. there must be a way to
prevent that temp file (as described in KB article 275934) from being
deleted or at least a way to change the path statement. I'm not a developer,
so Word path statements are foreign to me. If anyone finds a good work
around, please post it.
Azi - 13 May 2004 03:31 GMT
Hi Doug
Thanks for your help. This doesn't work either way. What I do is

1. open the mail merge do
2. at this point there is no mail merge info, it's all been strippe
3. i run the mail merge wizard again to include my outlook contacts and then add address block information to the letter and a greeting line
4. next i follow your directions and save the documen
5. when i click the data source button, this is where i get lost because Word cannot recognize an Outlook address book as a valid data source.
6. I can save the document and re-open it but all of the mail merge data is stripped again. No error this time though.

Is it possible that Outlook (*.pab) is not a valid data source

Thanks

Doug Robbins - Word MVP <dkr@NOmvpsSPAM.org> wrote
Try this

From the View menu, select Toolbars and then turn on the mailmerge toolbar

With the mailmerge main document, active, click on the leftmost button o
the mailmerge toolbar and select "Normal Word Document", Save the Document
then click on the second toolbar button (Open Data Source) and navigate t
the new location of the data source and open it. Now save the document an
then close it and re-open it and see if the data source remains attached

Please post back with the result so that we will know if this works
 
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.