The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Big mistake on web site submissions!

Here it is:

I have several sites that have used or still use CGI formail or aspmail for thier form submissions. None of the submitted information is put in a DB. Now I have all these emails with site submissions. I'm trying to put together an email list of the visitors that specified that they would like to receive email updates. So, I need to at least get the name and email address for each submission where the contact field = yes. Here's the worst part I think. All of these emails are in Outlook Express! There seems to be no way to effectively consolidate this data and make it more useable. Here's an example of the Outlook Express email:

Below is the result of your feedback form. It was submitted by
(BobLob@home.net) on Monday, April 29, 2002 at 13:31:50
---------------------------------------------------------------------------
contact_name: Bob Lob

street_address: 343 Web Road

city: HB

state: California

zip: 92649

day_phone: 714-555-5555

refered_by: Other

other: already member

plan_interest: Plan II

questions_comments: What does Plan II Cost?

Submit: Submit

I think I can handle this in the future by writing this information to a flat file or DB. Any suggestions on how to deal with the Outlook Express emails and data? Links to references about handling web site submissions? Tools that might help?