Automatic Import of Emails

Is there a way to automatically import incoming emails into a SQL
Server Database?
I know it is inefficient, but we have to run a number of rules on the
email after it is received. Store it in a database and be able to
connect other things, meetings, contacts, etc. Moving it back and
forth in chunks can be difficult and the overhead could spiral out of
control.
So we were thinking of moving it to the DB as it was retrieved.
What do you think would be a better solution to retrieve it?
Does my email make sense?Am 14 Jul 2006 01:13:51 -0700 schrieb leeroy881:

Quote:

Originally Posted by

Is there a way to automatically import incoming emails into a SQL
Server Database?

Maybe not import, but read. See xp_readmail/xp_findnextmsg (in SQL2000 sp3
and up) in BOL. With this and ServerAgent you can implement an automatic
mail processing system.

bye, Helmut|||Thank you Helmut.
I'll check it out.

Helmut Woess wrote:

Quote:

Originally Posted by

Am 14 Jul 2006 01:13:51 -0700 schrieb leeroy881:
>

Quote:

Originally Posted by

Is there a way to automatically import incoming emails into a SQL
Server Database?

>
Maybe not import, but read. See xp_readmail/xp_findnextmsg (in SQL2000 sp3
and up) in BOL. With this and ServerAgent you can implement an automatic
mail processing system.
>
bye, Helmut