Anyone seen or written a script that will automatically save emails of a certain address directly into an SQL database? I reckon it would be a CGI script, maybe PHP, which would run via cron at intervals throughout the day. I also know wordpress has a similar feature which creates posts from emails, I guess I could dig into that as well. Any thoughts? Thanks!
Grab a PHP script that reads from a POP3 account... you can find some at phpclasses.org. Step through the messages and save each one into an SQL database you have created... so the only work you have to do is matching things like title, sender, etc. to the columns of your database table.
Thanks Robert, PHP has been the answer, sort of. For those interested in such an app by using imap_open and imap_fetchbody you can fetch mail from your pop3 mail server from a PHP script, and then save it to a database or whereever you would like. The tricky part - and the part i'm still working on - is formatting/parsing the email message body. It's a complete nightmare trying to sort the line breaks after applying php's quoted_printable_decode function to the string.