Reference to Outlook in Excel application

Hello,

I have made an application where I send Outlook e-mail via Excel. Since
I don't know what version of Excel the user has I need a way to find the
correct reference to the MS object library.

I have seen a reference to a general "obl" that works regardless of
Outlookversion. Does anybody know where I can find it?

How can I check what mailprogram the user is running as standard,
Outlook or Outlook Express? Depending of answer I will use different
code to send mail. If the user is running a mailprogram other than MS I
would like to end the process with a message to the user.

Thanks in advance

I think what you're referring to is "late binding," where you don't include
a reference at all. Instead, you instantiate an Outlook Application object
as:

Set objOL = CreateObject("Outlook.Application")

Note that if you use late binding, you'll need Const declarations for any
Outlook constants that your code users.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Thor" <Thor@discussions.microsoft.com> wrote in message
news:A4E692C1-9E37-4C88-9692-A85D3B7D5F74@microsoft.com...
>
>
>
> Hello,
>
> I have made an application where I send Outlook e-mail via Excel. Since
> I don't know what version of Excel the user has I need a way to find the
> correct reference to the MS object library.
>
> I have seen a reference to a general "obl" that works regardless of
> Outlookversion. Does anybody know where I can find it?
>
> How can I check what mailprogram the user is running as standard,
> Outlook or Outlook Express? Depending of answer I will use different
> code to send mail. If the user is running a mailprogram other than MS I
> would like to end the process with a message to the user.
>
> Thanks in advance