parse incoming mail content and attacthments into tables

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?Hi
With SQL mail you can attach to the mailbox and process messages from it.
You may want to look at looping through xp_findnextmsg and calling
xp_readmail or use sp_processmail see Books Online for more information
regarding these procedures. Also check out:
http://msdn.microsoft.com/library/d...erverE-mail.asp
John
"roger@.springloose.net" wrote:

> 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?
>