Reference to Outlook in Excel application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top