Email Cmd

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a Command that generates an email message as follows:

Private Sub cmdSendOverdue_Click()

Dim strMessage As String 'Body of message
Dim strSubject As String 'Email Subject
Dim strTo As String 'To address
strTo = "TEST"
strSubject = "DSL Overdue Items"

strMessage = "The following items are overdue to the DSL." & vbCrLf & vbCrLf
strMessage = strMessage & "" & qryOverdueItems & vbCrLf & vbCrLf

DoCmd.SendObject acSendNoObject, , acFormatHTML, strTo, , , strSubject,
strMessage, True

End Sub

The issue is, I would like to list the query/table qryOverdueItems, as
attempted in the second 'strMessage' above.
Unfortunetly, this is not working. How can I get the above email message to
display the entire results of the query (basically be able to list an entire
table).

Is this possible?

Thanks in advance for your help.

.

Relevant Pages

  • Re: Email Cmd
    ... Thanks John. ... > Dim rsOverdueItems As DAO.Recordset ... > Dim strOverdueItems As String ... How can I get the above email message to ...
    (microsoft.public.access.formscoding)
  • Re: On Error GoTo is not working
    ... Dim strRequestID As String ... Dim strMessage As String ... MsgBox "Required fields for this form are: Request ID, Date, Name, ...
    (microsoft.public.access.formscoding)
  • Re: On Error GoTo is not working
    ... Dim strRequestID As String ... Dim strMessage As String ... MsgBox "Required fields for this form are: Request ID, Date, Name, ...
    (microsoft.public.access.formscoding)
  • Crazy email button
    ... I am writing in order to get your valuable help. ... which enables the user to send an email message based on the form's ... Dim stCognome As String '-- Cognome utente ...
    (comp.databases.ms-access)
  • Re: WHERE String ? Please Help
    ... Dim strMessage As String ... 'Dim strDateField As String 'Name of your criteria date field. ... Set lst = Me.lstVariety ...
    (microsoft.public.access.formscoding)