Web Based Email Development

Major Snag Hit

[chris_f]

Hi All,

I am looking into building a web based email platform (nice simple job ;)). I have everything mapped out and ready to program except one thing. How do I get emails from an account into a database (preferrably Microsoft Access, however, I will use SQL2000 if necessary)?

Any help will be greatly appreciated. If there are programs out there that already do this then a pointer in the right direction would be nice, however, I have a budget of £0.

Thanks Chris.

[Brett_Tabke]

Emails will come into a user spool file (mbox). You just dig the mail out of the spool file and xfer it over to your database. Usually, a cron or scheduled task will do it.

There are also hooks in most mail programs to launch an external app on new mail arrival. Under *nix, Procmail is one such app. I'm not sure under winders. That's your hook to grab the mail and put it in your db.

[sugarkane]

Or if you're using Perl and collecting mail via POP3, the Net::POP3 module is pretty easy to get to grips with for collection. You can then transfer the data into a db using the appropriate DBI module for the database you're using.

[chris_f]

Thanks for the response,

What if I'm using windows and code in .net?