Migration 97 to 2003 causes MailMerge to fail

  • Thread starter Thread starter Guest
  • Start date Start date
G

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, 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
 
Back
Top