Email reciepent after click of submit button

  • Thread starter Thread starter Karen Bosen via AccessMonster.com
  • Start date Start date
K

Karen Bosen via AccessMonster.com

I have a form that has an "assigned to" field. When this field is updated
and the submit button is clicked, I'd like to send an email to that person
"assigned to" to left them know that they have an issue waiting in the
database.

I have the table with the "assigned to" field" and the email addresses for
each person.

Does anyone have code on how I can do this???

Thanks,
Karen
 
Karen said:
I have a form that has an "assigned to" field. When this field is
updated and the submit button is clicked, I'd like to send an email
to that person "assigned to" to left them know that they have an
issue waiting in the database.

I have the table with the "assigned to" field" and the email
addresses for each person.

Does anyone have code on how I can do this???

Thanks,
Karen
Click to expand...

Use a ComboBox for AssignedTo and add the Email address as a hidden second
column. Then in the Click event of your button...

DoCmd.SendObject
acSendNoObject,,,Me.AssignedTo.Column(1),,,"SubjectText","MessageText"
 
Back
Top