Run-time error Automation Error

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

Guest

I have a macro that has been working great that opens Outlook, attaches an
email and sends it.
However, I have one user that has recently updated their computer and the
macro is now failing.
I get a Run-time error "-2147024770 (8007007e)' Automation Error The
specified module could not be found.
The code stops on the line:
Set OutApp = CreateObject ("Outlook.Application").

Any ideas why this is bombing on this one computer.
They are running Outlook, 2003 SP2 under Windows XP.

Thanks!

David
 
Are they running a script stopper, such as the ones from Norton or McAfee?
Those can stop your code from running and many of them don't like
CreateObject. If Norton you're out of luck. It can't be told to trust an
application. McAfee lets you trust code but it would have to be in an EXE or
DLL I believe.
 
I had the same problem but Sue Mosher has a solution for the Norton case -
see her post in the "Problem automating Outlook" thread.

Wes
 
Back
Top