dkinley

Hi, My name is Kesh. I am using the code you posted to send e-mail:
Dim sSubject As String
Dim sToName As String
Dim sDocName As String

sDocName = "rptnewsletterdatabase"
sSubject = "New Record Added for " & Me.ReferenceControlName
sToName = "you@yourdomain.com"

DoCmd.RunCommand acCmdSaveRecord
DoCmd.SendObject acSendReport, sDocName, acFormatRTF, _
sToName, , , sSubject, , False

In my case it runs and opens the e-mail and I have to send manually. I would like tthe e-mail to be sent without any manual intervention. In a secon stage I want the e-mail to be sent at a specific time.

Could you help me Please?
Thank you