Excel VBA - Mail Hyperlink

[KeithGargett]

Hi,

I'm trying to ask VBA to prepare a new email in outlook using the following code:

strbody = "<font size=""3"" face=""Calibri"">" & _
"Colleagues,<br><br>" & _
"New Request Saved in the following location: <br><B>" & _
ActiveWorkbook.Path & "</B>\<br>" & _
"Click on this link to open the request: " & _
"<A HREF=""file://" & ActiveWorkbook.FullName & _
""">Request</A>" & _
"<br><br>Regards, " & UserFullName

My issue is the network location where my active workbook is then saved has spaces in, and therefore the hyperlink to ActiveWorkbook.Path generated does not complete the link.
The macro also creates the save location (and stores in worksheet) so it is not known / cant be hard coded.

Thank you in advance for your help.

 

[Legacy 134911]

Replace:

ActiveWorkbook.FullName

With:

WorksheetFunction.EncodeURL(ActiveWorkbook.FullName)

 

[KeithGargett]

Works a treat, thank you.