Auto report email

R

Robbie

Option Compare Database
Please help, if I use the Data = False the report will email if there is
data and if there is no date. If I use Data = True the report will not email.
If I use On no Data on the report properties, the auto email fails.
Please advise

Private Sub form_timer()

If Data = False Then
docmd.sendobject acSendReport, "PICK TICKET REPORT", acFormatSNP, _
"[email protected]", "", , _
"CURRENT PICK TICKETS", , False
End If

End Sub
 
Top