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.

I have seen a similiar post here back in April - but no solution. Any helo
greatly appreciated. I know that the antivirus protection was also recently
upgrade to Symantec Antivirus Version 9.

Thanks!

Mark

Has your Macro worked in any situation where it had to use Outlook 2003 to
send the e-mail. Microsoft has increased the security so that other
applications cannot send e-mail through Outlook 2003. Once I know that this
is infact the case (that is the issue is limited to computers running Outlook
2003) I will tell you the solution.

"Mark Campbell" 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.

I have seen a similiar post here back in April - but no solution. Any helo
greatly appreciated. I know that the antivirus protection was also recently
upgrade to Symantec Antivirus Version 9.

Thanks!

Mark

Yes it has worked with Outlook 2003 up until last week when the virus
protection on the pc was upgraded and service pack 2 installed on the server
at work. The mail at work is managed using microsoft exchange - this has
always worked in the past prior to service pack 2 and the updated virus
protection.

Thanks

Mark

"Alok" wrote:

Has your Macro worked in any situation where it had to use Outlook 2003 to
send the e-mail. Microsoft has increased the security so that other
applications cannot send e-mail through Outlook 2003. Once I know that this
is infact the case (that is the issue is limited to computers running Outlook
2003) I will tell you the solution.

"Mark Campbell" 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.

I have seen a similiar post here back in April - but no solution. Any helo
greatly appreciated. I know that the antivirus protection was also recently
upgrade to Symantec Antivirus Version 9.

Thanks!

Mark

Mark,
I am sorry I will not be able to help you then. I had an issue sometimes
back where I was trying to use the Outlook object model to send e-mails but
it would not allow me to do that. Since you have a different problem.. maybe
someone else in the newsgroup can help you.


"Mark Campbell" wrote:

Yes it has worked with Outlook 2003 up until last week when the virus
protection on the pc was upgraded and service pack 2 installed on the server
at work. The mail at work is managed using microsoft exchange - this has
always worked in the past prior to service pack 2 and the updated virus
protection.

Thanks

Mark

"Alok" wrote:

Has your Macro worked in any situation where it had to use Outlook 2003 to
send the e-mail. Microsoft has increased the security so that other
applications cannot send e-mail through Outlook 2003. Once I know that this
is infact the case (that is the issue is limited to computers running Outlook
2003) I will tell you the solution.

"Mark Campbell" 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.

I have seen a similiar post here back in April - but no solution. Any helo
greatly appreciated. I know that the antivirus protection was also recently
upgrade to Symantec Antivirus Version 9.

Thanks!

Mark

The easy way i found is to add a second argument to the function CreateObject
but i don't know what consequences it could have on network use:

Set OutApp = CreateObject ("Outlook.Application", "localhost")

hope it could help u


"Mark Campbell" 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.

I have seen a similiar post here back in April - but no solution. Any helo
greatly appreciated. I know that the antivirus protection was also recently
upgrade to Symantec Antivirus Version 9.

Thanks!

Mark

Emri,

Thanks for your help - worked perfectly.

I still dont understand why my code stopped working or how this fix worked -
thks again for your help

"Mark Campbell" 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.

I have seen a similiar post here back in April - but no solution. Any helo
greatly appreciated. I know that the antivirus protection was also recently
upgrade to Symantec Antivirus Version 9.

Thanks!

Mark