I am in the process of developing an Ideas management database for the company which I work for.

I require an email facility driven by a Submit button from a form on Access, my problem is the email needs to be directed to the departmental manager selected on the form.

Managers details are stored in a table called Departments with following fields
Department - Manager - Email

Also a copy of the...