I am attempting to send an automatic notification when a record has been added/modified. I have place the following code in the after update module. This is working however, I do not want outlook to require the user to slick send. Is is possible to automatically send the mail without user involvement?
Private Sub Form_AfterUpdate()
Dim stdocname As String
stdocname = "customer complaint"
DoCmd.SendObject , stdocname, "html", "mbrooks@ctioptics.com", , , "Complaint entry/modification notice", "A complaint has been entered and/or modified"
DoCmd.CancelEvent
End Sub
Private Sub Form_AfterUpdate()
Dim stdocname As String
stdocname = "customer complaint"
DoCmd.SendObject , stdocname, "html", "mbrooks@ctioptics.com", , , "Complaint entry/modification notice", "A complaint has been entered and/or modified"
DoCmd.CancelEvent
End Sub
