Migration 97 to 2003 causes MailMerge to fail

[Guest]

I am having a problem converting an Access/Word application using mail merge,
from 97 to 2003. The application works fine in 97, using VB code in Access
to set up the Data Source and execute the mail merge, producing a new Word
document containing the merged data.

However, in 2003 it fails at the line wrdDoc.MailMerge.Execute with error
4605, This method or property is not available because document is not a
MailMerge main document.

I notice the MailMerge toolbar is greyed out in the merge document, whereas
in 97 it is available. I have tried enabling the toolbar in the code,
immediately before the execute, but it makes no difference. The merge does
work normally if it is performed from the Word document, but I need to get it
to work from Access.
The problem appears to affect more than one application, in fact I haven't
had any that work correctly.

Any help would be appreciated.

Thanks,

Colin Dimond

 

[Peter Hibbs]

Colin,

This is due to the extra security measures in A2003. You need to make
a registry change, see http://support.microsoft.com/kb/825765 for
details.

HTH

Peter Hibbs.

 

[Guest]

Peter, Many thanks, it worked a treat. Unfortunately I am not sure whether I
will be able to persuade my company to agree to reducing security!! I will
have to point out to them that it was never a problem in 97....
Cheers,
Colin