Receive Mail into SQL

[DennisTheMenace]

I did an advanced search, and came up short...
(Note: Cross Post. Also posted in the MySQL forum)
Has anyone ever set up ASP, SQL, or MySQL to receive e-mail messages? I need to set up a database that receives three line e-mails and writes them to the table. Each line being a seperate piece of data.
Line1 = Account ID
Line2 = User ID
Line3 = Amount

I'll need to validate those three lines and reply back if necessary... Would anyone be able to help point me in the right direction to look for more info? Thanks in advance!

-Dennis

=====================
Remember - YOU ARE UNIQUE!!!... Just like EVERYONE ELSE! ;o)

 

[JayKusch]

Hmmm ... Interesting twist! I have in the past used Perl to read emails from a POP3 server. Being that is is such a powerful string parser, I am sure you can create a small Perl app that reads the email, extract the fields of interest and creates a text file in a designated folder on your server.

From there you could create a scheduled, say every 5 minutes, SQL Server job that grabs the newest created text file(s) from the designated folder, imports them into a table, runs your commands to test wether they should be answered, emails out the needed ones, then runs xp_cmdshell to delete or move the processed files to another area for history purposes.

The above may be a good candidate for a DTS package. So that should give you a good head start. Here is a link to set up Perl to read a POP3 mailbox.

Enjoy!

Thanks

J. Kusch