Send Object

[garygdj]

Is there a way to tie a send object to a combo box on a form? I know I can write a query to pull information from a selection in a combo box using the [form][formname]thing. What I'm trying to do is I've created a database that allows many users to enter a request in a form. then when the form is complete they need to E-mail the form to their respective manager. I want them to choose from a combo box, then click on a button and the form is e-mailed to their manager for approval. I've gotten everything else to work accept for being able to choose the manager. I know I could also leave that blank and it will ask for them to enter the recipients name. If that's my only option I'm ok with that.

Thanks

PS If this issue has already been addressed I couldn't find it.

 

[databasedonr]

If you have your manager's email address and name in a table, use the manager's ID field as the value in the combo box, then on button click either do a DLOOKUP or run a query to retrieve the email address and use it as the recipient in your mail object.