SQL - Map emails to record in DB

[aconybeare]

Hi,

Does anyone know whether it is possible to integrate exchange with a bespoke sql server db,

I am about to start a project with asp.net which tracks manuscripts from submission to publication, a lot of the correspondence with authors is done through email we'd like to be able associate emails with a manuscript number or vice versa, this would ideally be both sent and recieved email.

This way when you view a manuscript you will immediately have access to all correspondence.

Does anyone have any ideas of how this could be achieved?

All help and or advice will be gratefully received

Cheers Al

[aconybeare]

I've been reading about SQL Mail, would it be possible to use this?

Does anyone know when an email is assigned an ID by exchange, and does anyone know how to get hold of it?

Guess once a mail is sent can query exchange for mail where sent by = x and subject = x etc.? Not sure how to actually do this, but you must be able to do it.

Received mail would have to be manually assigned to a manuscript as I can't see a way around that

Any thoughts or ideas.... anyone??