I'm fairly new at this, so I'm not sure if this is a simple task or not. I've only been able to find desktop applications on doing this and that's really not the way I want to go. What I'm trying to do is this: We have a program that sends email in a templated format (always containing the same info on the same lines) with a few attached files as well. We want the server to see them come in, parse the info out of the body of the email and insert into a few different tables. We also want to be able to save the images into another table. The first question I have is whether we write something that sits on the Exchange server or on the SQL server. If on the SQL server, I guess I'll have to figure out how to issolate one email address to point to the SQL server. Any ideas on where to begin?
I would look at using an Event sink on the exchange server to do this. Are all the messages going to one or two particular mailboxes if so you can use a store event sink. If they are going to a multitude of address then you are better of using a SMTP event sink. You can get more information on event sinks in the Exchange SDK which you can download from http://msdn.microsoft.com/exchange . I've done something simular with public folder content which I posted about which might help http://gsexdev.blogspot.com/2005/07/shared-mailbox-database-public-folder.html Cheers Glen wrote in message news:1130170005.739846.29620@o13g2000cwo.googlegroups.com... > I'm fairly new at this, so I'm not sure if this is a simple task or > not. I've only been able to find desktop applications on doing this > and that's really not the way I want to go. > > What I'm trying to do is this: > > We have a program that sends email in a templated format (always > containing the same info on the same lines) with a few attached files > as well. We want the server to see them come in, parse the info out of > the body of the email and insert into a few different tables. We also > want to be able to save the images into another table. > > The first question I have is whether we write something that sits on > the Exchange server or on the SQL server. If on the SQL server, I > guess I'll have to figure out how to issolate one email address to > point to the SQL server. > > Any ideas on where to begin? >
