I am trying to setup so I don't have to select the library in
Tools/references. I get "Run-time error 429: ActiveX component can't create
object". Isn't that correct to setup for a late binding?

Dim OutApp As Object
Dim OutMail As Object

Set OutApp = CreateObject("Object.Application")
Set OutMail = CreateObject("Outlook.MailItem")

Thanks

I was able to find the fix from ron de bruin website
Change outmail to Set OutMail = OutApp.CreateItem(0)
However, I get the warning message from Outlook that the attachment may
contain virus. Is it possible to hide the warning message completely from
Excel VBA?

"matelot" wrote:

I am trying to setup so I don't have to select the library in
Tools/references. I get "Run-time error 429: ActiveX component can't create
object". Isn't that correct to setup for a late binding?

Dim OutApp As Object
Dim OutMail As Object

Set OutApp = CreateObject("Object.Application")
Set OutMail = CreateObject("Outlook.MailItem")

Thanks

Shouldn't that be?

Set OutApp = CreateObject("Outlook.Application")

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"matelot" wrote:
|I am trying to setup so I don't have to select the library in
| Tools/references. I get "Run-time error 429: ActiveX component can't
create
| object". Isn't that correct to setup for a late binding?
|
| Dim OutApp As Object
| Dim OutMail As Object
|
| Set OutApp = CreateObject("Object.Application")
| Set OutMail = CreateObject("Outlook.MailItem")
|
| Thanks

Hi Matelot,

There is a thread 'Security Warning' in the Programming disussion group on
9/12/2006.
An add-in for Outlook may be of interest at
http://www.mapilab.com/outlook/security/

Anthony

"matelot" wrote:

I was able to find the fix from ron de bruin website
Change outmail to Set OutMail = OutApp.CreateItem(0)
However, I get the warning message from Outlook that the attachment may
contain virus. Is it possible to hide the warning message completely from
Excel VBA?

"matelot" wrote:

I am trying to setup so I don't have to select the library in
Tools/references. I get "Run-time error 429: ActiveX component can't create
object". Isn't that correct to setup for a late binding?

Dim OutApp As Object
Dim OutMail As Object

Set OutApp = CreateObject("Object.Application")
Set OutMail = CreateObject("Outlook.MailItem")

Thanks