how to hyperlink email in access (mailto:) 1

[saigonvietnam]

I have a email message body text include some like:

body = "first text" + "email@hotmail.com" + "second text"

First, Is it possible can I display this body text in a textbox field with the email part hyperlink? (no big deal if It is impossible)

The most essential part: what should I do to make the body text appear on the email in outlook with the email part hyperlink so when the one who receive the email can click on that link, and it will open a new email message?

My little access database is used to send email, keep track in order to preview the report later.

Thank You so much.

Looking forward to hear that it is doable.

Linhsy

 

[Remou]

Hi
I do not think you can do this with one text box. You would need to put "email@hotmail.com" in a separate box.
Then you could say:

strBody="<a href='mailto:email@hotmail.com'>email@hotmail.com</a>"

With objEmail
    .To = "contact@hotmail.com"
    .Subject = "Sending Email"
'Note HTMLBody, not Body
    .HTMLBody = strBody
    .Send
End With

 

[saigonvietnam]

Thank You so much, Remou