Email notification after changes made to form 1

[childlead]

hi.

does anyone how to code email notifications only when changes are made to the forms. for example, i have a bug tracking software made in access where upon pressing the exit button, access automatically sends an email to a specified user. when a user enters new notes, i want access to detect the changes and send an email to the specified user ONLY when changes are made. thank you for your help.

 

[rushdib]

Use [BeforeUpdate] event in the form and use SendObject (vba or macro) to send the e-mail.

 

[DougP]

I would do this

In your command button add this code

DoCmd.SendObject acSendNoObject, "", acFormatTXT, "youremail", , , "put your subject here", "put body of e-mail here", False
' Note the False means it will go out without user intervention. True will pop up and they have to click send.

Also note it will only go to the Outbox if they don't have their e-mail program open. then it will set there until they open their e-mail program DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive