Email reports and tracking sent date/time

[wnicole]

Im looking to be able to send a report and also track date and time sent in my database. Is there a thread you can point me to or sample you can send to help me know how to do this.


I already have in my database tracking of forms date and time. I just don't know how to track when I send a report from my database date and time. Also pending reports that haven't been sent.

[ranman256]

send the report then append a record to the log table.

DoCmd.SendObject acSendReport, "rptName", acFormatPDF, email, , , vSubj, vMsg
PostLog "Bob Smith" ,"rptName", email

'-----------
Public Sub Post2Log(pvUser, pvEvent, pvDescr)
'-----------
Dim sSql As String


docmd.setwarnings false
sSql = "INSERT INTO tLogs ([USER],[Event],[Descr],[EntryDate] ) values ('" & pvUser & "','" & pvEvent & "','" & pvDescr & "',#" & Now() & "#)"
DoCmd.RunSQL sSql
End Sub

the tLogs table has
[user]
[Event]
[descr]
[EntryDate] , general date format, default = Now()