I have a button in a access form and on click event I send email to the receipient.
On the message i have a field which is a hyperlink field in my access table.
The email is sent without any issue, but the hyperlink field just display the path. Is there a way i can make it real hyperlink on the email the user receives so they can just click on it?
please see code below
I have two fields Email1 and email2, i use sendobject to send email. Lk is my hyperlink field, i send the value of this in email. The user receives this on their email as a path d:\test2\log.maf
I want them to be able to just click on the link and go to the form. It shows the path but unable to click on it. Please see code below.
Will appreciate if somebody can show me the syntex to send hyperlink field on send object.
Private Sub Emailbtn_Click()
Dim emailse As String
If IsNull(Me.Email1) Or Me.Email1 = "" Then
MsgBox "Please Enter alteast one email to send email. !", vbOKOnly, "No emails will be sent."
If IsNull(Me.Email2) Or Me.Email2 = "" Then
emailse = [Email1]
emailse = [Email1] & ";" & [Email2]
"" & emailse, _
"Your action needed", _
"Please check this link " & " " & Me.Lk.Value, _