A
AccessHelp
Good morning,
I just posted the same tread in the programming section of this discussion
group.
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)
I just posted the same tread in the programming section of this discussion
group.
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)