Unanswered: Email notification sent to sender from address entered in field
I am in desperate need of a way to automatically send a notification email to a user when a work order has been assigned.
I have the fields “Assignee” and “Assig_Email” created in my work order input form. I would like an email to be sent to the individual entered in the Assignee field using the email address entered in the Assign_Email field.
I have seen some shared code on the Internet, but it was using lookup tables and was way too complex for my Access or VB experience.
Any code to share or suggestions would really be appreciated.
Dim strEmail As String, _
strSubject As String, _
strMessage As String
strEmail = Me.assig_email
strSubject = "New Work Order"
strMessage = "Dear " & Me.assignee & "," & vbNewLine & _
"This is an automated email to let you know you have a new work order. Have a nice day."
DoCmd.SendObject acSendNoObject, , , strEmail, , , strSubject, strMessage, False
Yes, I understand about the Security warning message. I read seveal posts on this issue. Is there a way to disable the debug form that pops-up when the "No" button is clicked. I don't want users to see a debug window each time they click on the "No" button.