Change body of Outlook e-mail location to hyperlink

[tiredofit]

In Excel, I have created a sub that creates an e-mail in Outlook and adds some text in the body.

In particular, I have text which is a location, such as:

C:\MyLocation\MyFiles\

The problem is this is displayed simply as text. I want it to be hyperlink.

Can it be done with VBA from Excel?

Thanks

 

[tiredofit]

Found this:

Dim Fileloc

Fileloc = "C:\MyLocation\MyFiles\"

.HTMLBody = "<a href=h>" & Fileloc & "</a>"

which does indeed turns the text as a hyperlink but when I click on it, it thinks it's a webpage and opens the web browser instead of Windows Explorer.

How can I fix it?

 

[tiredofit]

EDIT SORTED:

https://stackoverflow.com/questions/15224280/adding-hyperlinks-to-excel-email-body-text