I am trying to create a unique contact form for my website and I need a little help. Let me first mention that it has the following fields:

Name: <--One line text box
E-mail: <-- One line text box
Who would you like to contact: <-- Drop down list (This field shows the persons name in the box; exp. "John Smith" or "Jane Smith" and has their e-mail addresses as the special values. So when the user fills out the form and selects "John Smith" as the person they would like to contact, the hidden value becomes "John.Smith@website.com". Just the same, if the user were to select "Jane Smith" instead, the hidden value would become "Jane.Smith@otherwebsite.com".)

Subject: <-- Drop down list
Message: <-- Scrolling Text box

Now, I would like this form to do a few things (if at all possible.) Even if I have to use a cgi script, that is OK as I already have a few of those on the site(I didn't write them because I don't know how.)

I would like all of the results e-mailed to the contact the user selects in the "Who would you like to contact:" field. Using the example above if the user selects "John Smith" in the "Who would you like to contact" field, the form(once submitted) would e-mail the results to "John.Smith@website.com" or if the user selected "Jane Smith" the form would e-mail the results to "Jane.Smith@otherwebsitecom".

Also, I would like the form results to be saved to an Access database on the webserver as well as e-mailing them to the contact.

I have a web developer that said he could do it for me but he wants $500 to do it, and I don't have that in my budget. I hope that I have explained my situation as best as possible. I hope someone can help me with this. I can create a different contact page for each person but that would take up to much space on the webserver. Thank you for any help you can provide.

*** Added 10/07/2008 12:18 AM ***
*** I have MySQL access on the webserver. I have already created a database and a table. I would like to save the form results to that database if I can instead of the Access database, if anyone knows anything about PHP.***

I'd suggest you just google for let's say "php contact form" or something like that, and you'll have a billion howto's on your screen

$500 dollars just for a contact form? That is highway robbery!

Yeah it is. I told him that he was out of his mind. I mean $500 for one page, come on.

If you end up doing this yourself, I would read up on PHP form submissions. Here is a tutorial for beginners: http://www.w3schools.com/php/php_forms.asp
Then, I would read about the mail() function of PHP. Fortunately it is pretty easy to use: http://us3.php.net/function.mail
Here is a tutorial for using MySQL from PHP: http://www.w3schools.com/PHP/php_mysql_intro.asp
Here is the page from that tutorial about inserting into a database: http://www.w3schools.com/PHP/php_mysql_insert.asp

If you read about those topics a little, come back here and we'll help you with any specific questions you have.

Thankyou, you guys have been a great help.