POP3 to MySQL Import Tool (Visual Basic or similar)
Budget: Don't Know
I require a tool that can be setup as a windows service on a windows 2003 server to check a POP3 inbox at regular intervals and import any emails into a MySQL database
The POP3 server and account details, check interval, database connection/username/password, table name and column names should all be configurable - this can be done via an ini file or preferably an XML config file
The program should pull out the individual parts of the email into separate database fields
i.e to, from, cc, subject, html body, text body etc
Successfully imported emails should be deleted from the server, any that fail should be notified to me somehow - possible forward the email to another email account specified in the config file
Deliverables would be the source code, compiled program and documentation for setup
I'm not too bothered about what programming language is used, although Visual Basic would be preferred as I have experience with it myself



