Be gentle, I'm a beginner to Access...
I'm sending emails from Access. It works OK, but I want to place a link from a table in the body of the email. Does anyone know how to do that?
The links are placed in the table "tblTidsskrifter" And the field name is "indhold"


Here is the code of the "send emails" form:
Private Sub Kommandoknap8_Click()

Dim conn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strSQL As String
Dim strModtager As String
Dim intTidsskrift


Set conn = CurrentProject.Connection
Set rst = New ADODB.Recordset

intTidsskrift = Me!tidsskrift

If Len(intTidsskrift) < 1 Or IsNull(intTidsskrift) Then
intTidsskrift = 0
End If

strSQL = "SELECT tblemail.[email]" & _
"FROM tblemail " & _
"WHERE tblemail.[tidsskrift]='" & intTidsskrift & "';"

rst.Open strSQL, conn

If rst.BOF And rst.EOF Then
Else

Do Until rst.EOF
strModtager = strModtager & rst("email") & ";"
rst.MoveNext
Loop
End If


rst.Close
Set rst = Nothing
conn.Close
Set conn = Nothing

If Len(strModtager) > 1 Then

Application.FollowHyperlink "mailto:" & strModtager & "?subject=" & intTidsskrift & " &body=Følg linket for at se den nyeste indholdsfortegnelse fra " & intTidsskrift & "", , True

End If

End Sub