Force mailto hyperlinks to use Outlook

BlissC

New Member
Joined
Aug 28, 2017
Messages
41
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
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

BlissC

New Member
Joined
Aug 28, 2017
Messages
41
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

Well-known Member
Joined
Jul 9, 2009
Messages
1,871
Office Version
  1. 2013
Platform
  1. Windows
All worth a look. Particularly if it's Win10.
Get him to check Outlook is set as the default Client.


Win10
 

Watch MrExcel Video

Forum statistics

Threads
1,119,104
Messages
5,576,140
Members
412,700
Latest member
IIII
Top