I have a database with a list of process owners. The users of this database wants the process owners emailed when a form is updated with a click of a button. I can email to one person using a macro but this requires additional codeing which I am not all that great with. Any Access Experts available to answer this one?
I have a table containing the process owners names and email addresses
I have a form that requires the process owners to be selected from the table
Once the form is filled out, click on email, its to send all the selected process owners a copy of the form for their review.
table for process owners:(partial)
Prepared by, PBEmail, QE, QEEmail, ME, ME Email...and so on..
thank you in advance.