send e-mail to selected user
I am building a task management DB. I have a task form and a staff form. The task from contains staff member names and e-mail addresses. I have a staff field on the task form so that I can assign a task to them. I would like to send a message to the staff member chosen with the task title in the subject on submission of a new record.
I do not know how to select the e-mail since it is in a different form. Can anyone help?
Dave