I have a check box in my form and want to know if there is a way to have an email sent when ever the box is checked?
I have a check box in my form and want to know if there is a way to have an email sent when ever the box is checked?
Ill give it a go and see if it works. Thanks
It kind of worked. It opens an email dialogue box, but if the message is closed out a runtime error '2501' message - the sendobject action was cancelled occurs and stops the database to debug it. How can I have the database still run even if the email message box is closed. The code was pulled from the site that was noted above:
Private Sub Command164_Click()
DoCmd.SendObject _
, _
, _
, _
"sample@email.com", _
, _
, _
"My drawing update", _
"Message", _
True
End Sub
I would add error trapping and do whatever you want with that error:
http://www.baldyweb.com/ErrorTrap.htm
that worked, thanks