View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
 
Posts: 400
Default Run-time Automation Error

From the VBE, click Tools | References; can you see
Microsoft Outlook 11.0 Object Library
in the list? If not, Outlook is not correctly installed.

"David" wrote:

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