Run Time Automation Error - Help Needed
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
|