Outlook Automation 2003

[Linda]

I have an error coming up when using Set myOlApp = CreateObject("Outlook.Application") if the user has Outlook 2003. It works fine with Outlook 2000! The error I get is "Object library feature not supported" so presumably the object class for Outlook 2003 is different
Can anyone help me please

 

[Alisher H. Abdurahmanov]

I have an error coming up when using

Set myOlApp = CreateObject("Outlook.Application")
if the user has Outlook 2003. It works fine with Outlook 2000!
The error I get is "Object library feature not supported"
so presumably the object class for Outlook 2003 is different.
Can anyone help me please.

First, you must add link to Outlook 11.0 Object Library
in the Excel (Word, Access, etc). Visual Basic environment,
menu Tools / References. And then you can use code like this:

Dim appOutlook As Outlook.Application
....
Set appOutlook = GetObject(, "Outlook.Application")
If Err.Number <> 0 Then Set appOutlook = CreateObject("Outlook.Application")