detecting MSOutlook

[ajking]

I have an excel form which has a button that automatically emails the form but it only works if the user has msoutlook on their PC. is there code that will check to see if MSOutlook is present or not.TIA

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

 

[longhair]

ajking,

from ms vba help:
MailSystem Property Example

This example displays the name of the mail system that's installed on the computer.

Select Case Application.MailSystem
Case xlMAPI
MsgBox "Mail system is Microsoft Mail"
Case xlPowerTalk
MsgBox "Mail system is PowerTalk"
Case xlNoMailSystem
MsgBox "No mail system installed"
End Select

hth

regards,

longhair

 

[ajking]

thanks for the reply, that works to a degree but I was hoping for something that would differentiate between MSOutlook and Outlook Express. Any ideas?

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

 

[longhair]

ajking,

do a key word search for "outlook express" and then go to thread 707-276168, i think this is what you are looking for.

regards,

longhair