|
Here is a simple perlscript that you can use to retrieve email messages and insert them into a database. The way it would work is that you would create a user on your email server and subscribe that user to the list. Then schedule the perlscript to run every 30 mins or so. It will retrieve the messages and insert them into the specified database.
If you need further help please email me off list. You will obviously need perl installed on a computer somewhere running this script to use this solution. I use ActiveState Perl and so can only help you if you are using this product.
Regards Trevor
-----Original Message-----
Hi All
This was part of reply of another thread, so sorry if you have read this already. (I wanted to give it another shot as a new subject)
-> So here is what it needs to do. <- Periodically use POP3 to collect email from my mail server and then insert the data into a Table in a SQL Database.
I looked all over the web for software to Email->SQL (at least what google could find) and only found one that might do what I need but it costs $300.
I have tested Delphi and I could write one in a couple of hours. But thought I would ask the list here.
I have Exchange Server, And, No I don't want to it. To me that is like buying a HumVee to drive over a speed bump ;-)
Thanks Ben Johansen - http://www.pcforge.com
|
mail2sql.pl
Description: mail2sql.pl
mail2sql.cfg
Description: mail2sql.cfg
