Automate an email to be sent...

[DaniBoy]

Hello everyone,

I have looked and cant find anything where someone helped someone with the same thing I want. Is it possible or not?

I want to send an email of a report "I can do that", but I want to automate this email so that it will always be sent at the same time automaticly. I think with an if statement might be done but I have no idea!! How do I tell it to do it at the time I want it to go?

Thanks guys

joke " If I keep doing the amazing job that thanks to you am doing, am gonna run my self out of work!!!" My boss told me that!! mmmmmm hint or what?jeje

DaniBoy

 

[DaniBoy]

Would this Work?

I actualy did this to the regular code:

Private Sub Command67_Click()
On Error GoTo Err_Command67_Click
Command67.ForeColor = vbRed

Dim stDocName As String
Dim stDocName1 As String
Dim Mytime

Mytime = #11:55:00 AM#
stDocName = "AM Email Tracker Report"

If Time = Mytime Then
DoCmd.SendObject acReport, stDocName
End If

Exit_Command67_Click:
Exit Sub

Err_Command67_Click:
MsgBox Err.Description
Resume Exit_Command67_Click

End Sub

How can I malke it just a code that runs with out clicking, In other words to send it if just the database itself is open.

DaniBoy