Email using a user-selectable field.

Email using a user-selectable field.

Hello everyone,

I'm writing a form application that will need to send an email to an address that is associated with a name that a user selects via a drop down.  The issue I'm having  is a bit hard to describe, so please see below:

1.) User selects Name of person they want to contact from a drop down.
2.) App should then look up the entry for the name to find the email address.
3.) Form should be sent to that email address.

The problem is that in the drop down, you have to define values straight away, and so they have to either be email addresses or names, and there is no way to associate a name with an email address.  If I could define a data table initially, then I would be set, but I can't find anyway to do that.  I'm sorry if I'm being stupid here!  Thanks for your time.