Force mailto hyperlinks to use Outlook

[BlissC]

Is there a way to force mailto hyperlinks in Excel workbooks to use Outlook, perhaps using VBA?

A user of one of my workbooks phoned me complaining that the link in the workbook, which should open a new email window with the email addresses pre-filled and a short message, opens up Google Chrome each time he tries to use the link. Having searched around online for fixes for this problem, I told him how to check the settings in Chrome to make sure handlers in Chrome weren't causing the issue, and to check that Outlook is set as the default mail app, which he did, but he's still getting the problem. No-one else using the same workbook is experiencing this problem. This is on a corporate system where all of the devices have Outlook installed, and the IT dept set the defaults for applications.

I know it's not the end of the world, and he can open a new email window in Outlook himself and type in the details, but it's rather frustrating, particularly as it seems to be only one user that's affected at the moment. I don't know if there is a way using VBA to force mailto's to use Outlook, but if there is I'd be grateful if you could tell me how to do this, as I'm out of ideas for fixing it.

Thanks,

Bliss

 

[daverunt]

Sounds like Chrome settings for GMail. I can't see it being anything else. It's all about which is set as the default EMail program. Needs to look a bit deeper.

Whenever I click on a mailto link Chrome opens a new window for Gmail. How do I disable this? - Google Chrome Community

 

[BlissC]

Hi Dave,

Yes, that was one of the pages/solutions I found. I gave the user step by step instructions, including that it might say 'site settings' rather than 'content settings', and sent him a couple of screenshots I took while I was looking for it on my PC. There'll only be Outlook, MS Edge and Chrome installed on his machine because that's all IT install. I'll ask him if he's used the web-based Gmail on his work laptop.

 

[daverunt]

All worth a look. Particularly if it's Win10.
Get him to check Outlook is set as the default Client.

How to Make Outlook Your Default Email Client

Make Outlook your default email, calendar, and contact program by following these step-by-step instructions. Updated to include Outlook 2019.

www.lifewire.com

Win10

Windows 10 – Fix email links opening Google Chrome (change to Outlook) – IT Support Guides

How to Change Mail Handler in Windows 10 for Default App Settings?

www.itsupportguides.com

How to Set Outlook as the Default Mail Client

After you install Outlook (doesn't matter which version), chances are it will not get recognized as the default client. Instead of having to jump to

appuals.com