Hello All -

I am looking for a way to capture data in an email body into SQL Server.

Can someone help me out?

Thanks
Kristina

In article <OS8A2KzwDHA.2316 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Kristina Ledford
<noemails (AT) noemails (DOT) com> writes

Depends where the email is and on what system. For example-

You could try xp_readmail and its associated extended procedures to read
from a mail box if setup correctly as the SQL Mail profile.

You could write an application that used WebDav to read a message from
an Exchange store.


There is nothing native in Dts that can do this.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I've actually got SQL Mail up and running - but found that it does not
support HTML =(

I am looking into alternatives.....




"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:BqS0DaEi3h3$EwOM (AT) sqldts (DOT) com...