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

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

Set rst = Nothing
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