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

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

Hi AA....
I just checked and while it was there, it was not checked. I won't be able
to test this until Monday when I can install the program at the location that
is not working, but at least it looks like a possible solution. Thanks much
for the direction! I'll let you know if this resolves the issue.

David

"AA2e72E" wrote:

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

What is VBE? I have this exact problem and error message and unable to fix.
--
Ozzie


"AA2e72E" wrote:

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