VBA Make link active in Lotus notes

[Katy Jordan]

Hi, does anyone know how i can make the following link active in Lotus Notes, the cell has a named range Link. I have a code that works, i.e sends email via VBA but i want to make the file path active so the user can click and open the folder.

C:\Test/2011

 

[Katy Jordan]

John, I have text in A4, A12, the link in A14, text on A16, so do i have to use this multiple times for each range?

Sheets("Sheet1").Range("A4").Text

Similar to the way I showed you for the email addresses. For example, if the text is in cell A4 on Sheet1, change:

    HTMLbody = "< p>Links to files on local computer:< /p>" & _
        "< a href='file:///f:\temp\excel\test.csv'>test.csv< />< br>" & _
        "< a href='file:///f:\temp\excel'>Excel folder< />"

to:

    HTMLbody = "< p>" & Sheets("Sheet1").Range("A4").Text & "< /p>" & _
        "< a href='file:///f:\temp\excel\test.csv'>test.csv< />< br>" & _
        "< a href='file:///f:\temp\excel'>Excel folder< />"

Put each paragraph of text between a paragraph opening tag (< p>) and its closing tag (< /p>) in the HTML code - see http://www.w3schools.com/tags/tag_p.asp. The < br> tag is a line break - see http://www.w3schools.com/tags/tag_br.asp

 

[kingveej]

Did it all work in the end?

I've been down the MIME type route in getting the link to open. However, upon clicking the link, the browser is throwing up an error that it does not recognise the protocol. It seems to centre around the "file:///" part of the HTML getting omitted by Lotus Notes - although it handles http fine.

Checking the document source of the email, with the exception of the Lotus Notes special characters that get added, it all looks fine. Copying and pasting from the email source to the browser address bar works fine also.

I'm just trying to work out whether its a Lotus Notes issue, or a configuration issue.