emails > database

They have: 133 posts

Joined: Sep 2000

Hi,

I have a couple of questions, which I hope can be answered here.

I would like to save all emails received by my server, to a database.

Ok.

Lets say that a mail is sent to:

[email protected]
subject = "hi"
message = "how are you?"
from = "[email protected]"

I then want to put that information into a field:

to = "hotcut"
subject = "hi"
message = "how are you?"
from = "[email protected]"

The question is.
How do I do it? Do I need any plug ins? Does IIS give me this option?

Hope you can help, or atleast give an URL for a toturial Smiling

Thanks!!!!
¨casper

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

Is IIS handling your incoming mail? To the best of my knowledge IIS can't do this for you. You're going to have to build a vb program or script that scans the incoming mail folder, opens any emails in it, parses the email into the fields you want and store them in the database. No small task.

PJ | Are we there yet?
pjboettcher.com

They have: 601 posts

Joined: Nov 2001

Or could just write a script that writes all the information to a database the same time as writing it to the smtp server so that you get the info firing off to your mailbox and at to the database all in one go...

- wil

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.