Tom’s Tutorials For Excel: Reading the Registry for Your Email (non-Web Mail) Client
Here’s a macro that reads your Registry and tells you the name of your email client. This does not include web mail such as accounts in Gmail and Yahoo.
My email client is Microsoft Outlook.
When I run this macro, this is what I see.
Here’s the macro I used to produce the above Message Box.
Sub EmailClient() Dim eClient As Object Set eClient = CreateObject("WScript.Shell") MsgBox eClient.RegRead("HKLM\SOFTWARE\CLIENTS\MAIL\") Set eClient = Nothing End Sub
Neat trick, unless you’re using Gmail, which leaves the registry alone.
Thanks for pointing that out Jon. I’d forgotten about the expanded email client landscape with these newer options such as Gmail.