Run Time Automation Error - Help Needed

[Mark Campbell]

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

 

[Alok]

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]

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]

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.

 

[emri]

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]

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