I have completed a form page in Dreamweaver CS3 with a submit button. My goal is to have people complete this form and hit the submit button and the information be emailed to me. How do I set this up to email to me once Submit button is clicked?

You need to use php or CGI to create a script to proccess and send the email.

Here is an example of a php email script:
<?php
$fname = $_REQUEST['fname'];
$lname = $_REQUEST['lname'];
$phone = $_REQUEST['phone'];
$uname = $_REQUEST['uname'];
$pass = $_REQUEST['pass'];
$com = $_REQUEST['com'];

/*Sending Email*/

$to = "someone@gmail.com";
$subject = "Your project";
$message = "
Form1 Information
Firstname = $fname
Lastname = $lname
phone number = $phone
Username = $uname
password = $pass
comments = $com";
$from = "$fname $lname";


if(mail($to, $subject, $message, "From: $from"))
echo "Mail sent";
else
echo "Mail send failure - message not sent";
?>

in your form tag where it says action make it like this action="proccess.php"

name all of your form fields match all of the $_REQUEST[''];
functions noted at the top of the page and place your email address instead of youremail@gmail.com on the .

that script will work if you have php on your server witch most servers do.