How do I find the name of my Default Email program for CreateObject()

Hello foxguy,

This macro will return the program name of the default email account.

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

Hello foxguy,

You will have to use RegEdit to open the registry and search for the string Mailto. What version of Windows are you running the macro on?

Hello Foxguy,

Vista is an entirely different operating system. I don't have Vista and can not advise you on what to look for and where it might be located.

I 'm running vista (ultimate x32) too... I didn'r get this error... answer was OUTLOOK.EXE

Leith;

I changed your line:

Please Login or Register  to view this content.

(I found that key in Register) and got the answer "WinMail.exe".

I am using Windows Mail, but it won't accept my setting it as the default. Every time I set it to the default, it just reverses my change.
Would you guess that I have probably found the correct Default Email Client?

Hello foxguy,

Without having a Vista system whose registry I can check, I can not say for certain it the correct key. However, if I were to make an educated guess then I would say it probably is. If you run the macro on another system, the macro may not work because of a different registry setup. The macro I provided will work with Windows 2000 through XP. Did macro work?

Your profile says you are using Excel 2002, but not which Windows OS you have. In the first post you say you want the default email program for Excel 2003. Finally, you mention Vista. System architecture changes from release to release. Sometimes very small changes are made and sometimes large changes are made. This is why it is important you be clear about what software and hardware you using.

Leith;

Yeah, I don't know how, but somehow I got it into my head that I had Excel 2003. I actually had to check About Excel for disabled items and noticed that it really was 2002. My bad.
Your macro did work after I changed the line. Now I just have to figure out how to use the result (See thread "How do I create an instance of Thunderbird" for my most recent problem. You're right, I had to change the line back after I made Thunderbird my default. Seems to me there should be a better way to determine the default client.

Hello foxguy,

It would be nice, but when dealing with registry there really isn't. The best thing to do is use an API macro to read the system version and call the correct macro for the installed OS.