To put a hyperlink from access in body e-mail outlook

[Tonaldo]

Hi,

I have a form with:
- e-mail adress
- subject (text)
- reference (hyperlink to a pdf document on the server)

Now I have a VBA code who allows me to open an e-mail in outlook, with the e-mail adress, the subject and in the body the hyperlink:

Dim mess_body As String
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
 
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
.BodyFormat = olFormatRichText
.To = Me.emailadress
.Subject = Me.subject
.Body = Me.referece
 

Problem: the hyperlink in the e-mail is displayed as a text format (like a hyperlink is built in access)

For Example:

2000#P:\Represe ntation\documen t2000.pdf#

What I want is that in the body of the e-mail, just the display text (here: 2000) is and that the link there still behind is (here: P:\Representati on\document2000 .pdf ) --> like it is on the access form

So that I can e-mail the link to a person (who has also access to the server) instead of sending the pdf file.

Can anyone help me? Has a tip?

Greetings and thanks,
Tonaldo

[Tonaldo]

Ok, thanks for the help Mariostg.

Looked into the rtf clues but didn't find a solution.

Anyone else has a suggestion to solve my problem?

[Tonaldo]

okay, got an answer

just needed to add "file://"

But thanks Mariostg again, wouldn't have found it without your help! (to split the hyperlink first)!

[Mariostg]

Oh this is what you were looking for... :) Gee I use this all the time. You use <a href=... if you want to refer to a website. And file:// to refer to a file in a folder.
By the way, if you want to avoid problems with such links, avoid spaces when you name your files and folders.

[Tonaldo]

Yeah, thanks for the help and the tips!