Automation Error



Good morning,

I just posted the same tread in the programming section of this discussion

I use the code (a small portion of what I use) below to send my Excel sheet
via email using Microsoft Outlook. Whoever uses that code has no problem
using it, except one user.

Everytime he uses it, he receives an automation error (Runtime error:
2147024770(8007007e). I checked the References on his Excel, and he does use
all the references that I use.

Thanks. Here is the code:

Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation Error 0
Automation Error 0
automation error 0
Automation Error 0
Automation Error 0
Automation error 1
Automation Error and Crash 0
Automation Error 440 1