Save mails to database

> Is there a way to save incoming & uitgoing mails to a database? I'm trying
> to
> create an online support service (with support tickets), and it would be
> helpfull if the mails were stored in a database so I can see which client
> sent
> what mail.

Ideally, you'd forgo email and have all communication back and forth done
via the web site and web forms, allowing you to input into the database as
needed. Those web forms, could, of course also SEND emails, but you'd want
the data to come directly from the web forms.

Otherwise, you'd have to develop some sort of email parsing system that
could properly ID the emails and store them in the proper fields in the DB.

Or, for a super-simple solution, make sure each support ticket contains a
unique ID number of some sort and then store all the emails in an email
system that has a decent search.

FYI, there are several open source help-desk systems already out there and
many more commercial ones. It might make the most sense to invest in one of
those instead of reinventing the wheel.

-Darrel