Gasman: sorry about the snippet. here is the full code from the send email command button.
Private Sub SendeMail()
Dim rs As Recordset
Dim vRecipientList As String
Dim vMsg As String
Dim vSubject As String
Dim vID As String
Set rs = CurrentDb.OpenRecordset("SELECT * FROM qryemailcontact")
If rs.RecordCount > 0 Then
rs.MoveFirst
Do
If Not IsNull(rs!EmailAddress) Then
vRecipientList = vRecipientList & rs!EmailAddress + rs!FFIDNO & ";"
rs.MoveNext
Else
rs.MoveNext
End If
Loop Until rs.EOF
vMsg = "Your Reference is" & " " & " " & Me.txtMessage.Value
vSubject = Me.txtSubject.Value '"Your Subject here 255 Characters ..."
#DoCmd.SetWarnings False
DoCmd.SendObject , , acFormatRTF, "rfortune@ntlworld.com", , vRecipientList, vSubject, vMsg, False, True
MsgBox ("Email successfully eMailed!")
DoCmd.SetWarnings True
Else
MsgBox "No contacts."
End If
End Sub#
The fact that you are wiling to take another look, is very much appreciate,
as mentioned before i am not a professional and rely on this forum for the best possible practice .
Regards Ypma