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

Thor

If you want to ensure that it will work for any version of Outlook, consider
using late binding as described here
http://www.dicks-clicks.com/excel/olBinding.htm

As for your second question, I don't know how to find the default mail
client. I saw the same question a couple of time using Google, but none of
them were answered.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Thor" wrote in message
...
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

Dick Kusleika has a web page at:
http://www.dicks-clicks.com/excel/olBinding.htm
that explains this with Outlook

Tom Ogilvy posted this recently:

Here are some more extensive references on binding:

Use late binding - don't have a reference to excel.

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever Possible

Thor wrote:

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

--

Dave Peterson