Hyperlink Email Outlook

When I put the string "File:\" & Application.ActiveWorkbook.Path
(from Excel)
into the body of an Email, the link in the email stops at the first space.
Example: the full string becomes :"File:\C:\Program Files\Bla\Word.doc"
the link stops between Program and Files.

Does anyone knows how to make the spaces part of the link?

How are you placing the link in the email? Manually or via code?

You need to make sure your bodyformat is html and if your pasting manually then I believe you need to replace the spaces with "%20".

Here is how to place a link in an html email via code.

VB Code:

Option Explicit
'Add a reference to MS Outlook xx.0 Object Library
Private Sub Command1_Click()
    Dim oApp As Outlook.Application
    Dim oEmail As Outlook.MailItem
    Set oApp = New Outlook.Application
    Set oEmail = oApp.CreateItem(olMailItem)
    oEmail.BodyFormat = olFormatHTML
    oEmail.HTMLBody = "<A href='file://D:\Program Files'>D:\Program Files</A>" 'modify to your filepath
    oEmail.Display
End Sub

Did you know that if you turn the back-slashes into slashes
the file openes out of the internetexplorer?

Now it openes in Iexplorer.

I thought I had it.
I'm trying to open an Excel sheet in the email link.
When I open the link from the email
Excel openes the excelsheet within Iexplorer.
How do I open this sheet out of the internet explorer??