Hyperlink Email Outlook

[HWijngaarD]

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?

[RobDog888]

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.

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

[HWijngaarD]

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

Now it openes in Iexplorer.

[HWijngaarD]

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??