I would like to receive and send e-mail in SQL.

The environment is Exchange 2003, SQL 8, on MS SBS 2003.

The reason is more a practical one: I could tag messages with IDs to associate these with actions in the database. I am running a small shopping site, and instead of sending via Outlook, I want to us ASP to generate any message that is required, such as order confirmation, customer queries, actions with suppliers, etc.

Is there a system out there doing this? Has someone done it? What is the best way to set it up?

I am after a simple solution (if there is ever such a thing ) one table with e-mail, a XRef table which links the order / supplier / customer tables.

Any hint, idea, etc would be much appreciated.

Thanks and regards,