How to parse a email and reply based on the parsed email

#1

Ì have a requirement to write a email handler that can receive a
incoming email and do parsing and based on some of the keywords to
perform a appropriate task handler and reply to the email or action
the email.

Can somebody please share the code and how to implement a process by
which a DTS ActiveX VB Script or T-SQL code can act as a email handler
and how can we have this code to automatically handle on a incoming
email.

Thanks
Karen

#2

One option is that there are extended stored procedures in SQL Server
for processing mail if you are using SQL Mail. You can find
information on using these at:
http://www.mssqlserver.com/articles/sqlmail_p4.asp

-Sue

On 22 Oct 2004 05:58:07 -0700, karenmiddleol (AT) yahoo (DOT) com (Karen
Middleton) wrote:

Quote:

Ì have a requirement to write a email handler that can receive a
incoming email and do parsing and based on some of the keywords to
perform a appropriate task handler and reply to the email or action
the email.

Can somebody please share the code and how to implement a process by
which a DTS ActiveX VB Script or T-SQL code can act as a email handler
and how can we have this code to automatically handle on a incoming
email.

Thanks
Karen

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to parse a email and reply based on the parsed email

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How to parse a email and reply based on the parsed email - 10-22-2004 , 07:58 AM

Re: How to parse a email and reply based on the parsed email - 10-22-2004 , 09:50 AM