Access word mail merge error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fraggle257 - 16 Jan 2006 11:55 GMT

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!

Reply to this Message

Doug Robbins - Word MVP - 16 Jan 2006 12:25 GMT

Are there any auto macros in the templates? If so, hold down the shift key
when you open either the template or a document created from it.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> 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
[quoted text clipped - 23 lines]
>
> Many thanks, in advance!

Reply to this Message

Fraggle257 - 16 Jan 2006 13:25 GMT

Thank you for your input! The document template certainally does have
some macros in it, however, I have tried the trick you suggested and it
is still crashing. Any other ideas?

Many thanks!

Emma

Reply to this Message

Doug Robbins - Word MVP - 16 Jan 2006 14:55 GMT

Do you know what the macros are trying to do?

When you say open the template, do you mean create a new document from the
template by selecting New from the File menu?

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thank you for your input! The document template certainally does have
> some macros in it, however, I have tried the trick you suggested and it
[quoted text clipped - 3 lines]
>
> Emma

Reply to this Message

Fraggle257 - 16 Jan 2006 15:16 GMT

It may still have a macro for inserting pictures, no other macros. I
think I have narrowed the problem down to being something about the
database that I merge from, as I have created totally fresh word
documents from the database and they still crash. When I say I open
the document, I have done both opening the template as a .dot to try
and edit the template and creating a new document from the template by
selecting New from the file menu.

Thanks!

Emma

Reply to this Message

Doug Robbins - Word MVP - 16 Jan 2006 18:47 GMT

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item and try
connecting the database by the different options that you are then presented
with.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> It may still have a macro for inserting pictures, no other macros. I
> think I have narrowed the problem down to being something about the
[quoted text clipped - 7 lines]
>
> Emma

Reply to this Message