Somewhere on the mail-merge screen is the option to connect to the database. In Word 97 (and as I remember also in Word 2000):
- step 1 = make the document
- step 2 = define the datasource (must be done early in step 1, because the data definitions are needed for making the document)
- step 3 = go ahead
- What happens if you make a new document, and connect it to the new location of the data. That should be OK.
- What happens if you use the step 2 dialog to point an existing document to the new file location? That seems the crucial step. And if it works it's much easier than creating them from scratch, of course.
- Are you sure the rename to the old file location was OK, and the program has access to that old file?
Hope this helps.
In the course of my work, I have created a database to collect results from tests (scientific type experiments) I have carried out. I have then merged these results into word documents to generate reports about these tests. Both the database and the word templates (*.dot files) I use to merge my documents are stored on my hard drive.
I recently re-installed the operating system on my machine and during this process I renamed the folder containing the database. Ever since this point, when I try and open any of the templates or the word documents that have been created from these templates, word crashes with the following error:
Unknown error returned from application. Error caught at [file Connect.cpp, line 699], operation cancelled. Contact technical support if this error persists.
Through trying many ways to fix this problem, I think I have narrowed the problem down to being related to the fact that the word documents are expecting to find a database in one location and the database is no longer there. However, I have tried putting the database back in its old location to no avail.
Does any one have any ideas on how to fix this problem? I have many of these templates, so to create them all over again from scratch would take a long time.
Many thanks, in advance!