If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Run-time error Automation Error
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 |
Ads |
#2
|
|||
|
|||
Run-time error Automation Error
Are they running a script stopper, such as the ones from Norton or McAfee?
Those can stop your code from running and many of them don't like CreateObject. If Norton you're out of luck. It can't be told to trust an application. McAfee lets you trust code but it would have to be in an EXE or DLL I believe. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "David" wrote in message ... 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 |
#3
|
|||
|
|||
Run-time error Automation Error
I had the same problem but Sue Mosher has a solution for the Norton case -
see her post in the "Problem automating Outlook" thread. Wes "Ken Slovak - [MVP - Outlook]" wrote: Are they running a script stopper, such as the ones from Norton or McAfee? Those can stop your code from running and many of them don't like CreateObject. If Norton you're out of luck. It can't be told to trust an application. McAfee lets you trust code but it would have to be in an EXE or DLL I believe. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "David" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automation Error | Lightknight | Outlook and VBA | 3 | April 4th 06 02:46 PM |
allow me to run macro time initiated | hirosh | Outlook and VBA | 1 | April 1st 06 06:40 AM |
error (0x80040115) sending and receiving email messages first time | Houmom | Outlook - General Queries | 3 | February 6th 06 05:45 AM |
run time error | nuti | Outlook and VBA | 0 | January 17th 06 01:13 PM |
How do I fix time-out error on OE6? | C & M Blankenship | Outlook Express | 3 | January 10th 06 06:21 AM |