Handling Bounced Emails

We use CDonts to send email from SQL 2k & IIS 6.0. All the email is "From:
server@.myserver.com", it has a "Reply To: ourcustomer@.thieremail.com" that
is the user we are sending on behalf of, so to speak.
I need to process undeliverable emails (bounced email is the term yes?).
Looking for suggestions, using ASP or SQL is preferred.
Thanks,
Dan FoxleyHi
If you are not returning the emails to a profile that is set up so that SQL
Server can read the mailbox then you can not do it from SQL Server. If you
can access the emails using SQL Mail, then you may be able to read then with
xp_readmail and parse and process them accordingly, unfortunately you may
have to deal with a multitude of formats.
John
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
> "From: server@.myserver.com", it has a "Reply To:
> ourcustomer@.thieremail.com" that is the user we are sending on behalf of,
> so to speak.
> I need to process undeliverable emails (bounced email is the term yes?).
> Looking for suggestions, using ASP or SQL is preferred.
> Thanks,
> Dan Foxley
>|||Are there options to using SQL Mail without an Exchange server? Looks like
SQLiMail in SQL 2005 will not use a MAPI client.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OrhAbMt5EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi
> If you are not returning the emails to a profile that is set up so that
> SQL Server can read the mailbox then you can not do it from SQL Server. If
> you can access the emails using SQL Mail, then you may be able to read
> then with xp_readmail and parse and process them accordingly,
> unfortunately you may have to deal with a multitude of formats.
> John
> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
> news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
>> "From: server@.myserver.com", it has a "Reply To:
>> ourcustomer@.thieremail.com" that is the user we are sending on behalf of,
>> so to speak.
>> I need to process undeliverable emails (bounced email is the term yes?).
>> Looking for suggestions, using ASP or SQL is preferred.
>> Thanks,
>> Dan Foxley
>|||Hi
SQLMail can be configured to use a non-exchange email account, but I have
never done it. Looking at CDONTS you can access a SMTP login (logonSMTP)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_denali_session_object_cdonts_library_.asp
and from there access the inbox and messages within it.
John
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:%23hUyOZu5EHA.4040@.TK2MSFTNGP14.phx.gbl...
> Are there options to using SQL Mail without an Exchange server? Looks
> like SQLiMail in SQL 2005 will not use a MAPI client.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OrhAbMt5EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> If you are not returning the emails to a profile that is set up so that
>> SQL Server can read the mailbox then you can not do it from SQL Server.
>> If you can access the emails using SQL Mail, then you may be able to read
>> then with xp_readmail and parse and process them accordingly,
>> unfortunately you may have to deal with a multitude of formats.
>> John
>> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
>> news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
>> "From: server@.myserver.com", it has a "Reply To:
>> ourcustomer@.thieremail.com" that is the user we are sending on behalf
>> of, so to speak.
>> I need to process undeliverable emails (bounced email is the term yes?).
>> Looking for suggestions, using ASP or SQL is preferred.
>> Thanks,
>> Dan Foxley
>>
>|||This seems like the solution. I've heard of VERP Variable Envelope Return
Path, mainly used in the Unix world for prepending each email recipient with
a unique "From:", have you seem implementations using SQL?
Thanks,
Dan
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23s2NQ3x5EHA.3472@.TK2MSFTNGP09.phx.gbl...
> Hi
> SQLMail can be configured to use a non-exchange email account, but I have
> never done it. Looking at CDONTS you can access a SMTP login (logonSMTP)
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_denali_session_object_cdonts_library_.asp
> and from there access the inbox and messages within it.
> John
> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
> news:%23hUyOZu5EHA.4040@.TK2MSFTNGP14.phx.gbl...
>> Are there options to using SQL Mail without an Exchange server? Looks
>> like SQLiMail in SQL 2005 will not use a MAPI client.
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:OrhAbMt5EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> If you are not returning the emails to a profile that is set up so that
>> SQL Server can read the mailbox then you can not do it from SQL Server.
>> If you can access the emails using SQL Mail, then you may be able to
>> read then with xp_readmail and parse and process them accordingly,
>> unfortunately you may have to deal with a multitude of formats.
>> John
>> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
>> news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
>> "From: server@.myserver.com", it has a "Reply To:
>> ourcustomer@.thieremail.com" that is the user we are sending on behalf
>> of, so to speak.
>> I need to process undeliverable emails (bounced email is the term
>> yes?). Looking for suggestions, using ASP or SQL is preferred.
>> Thanks,
>> Dan Foxley
>>
>>
>|||If I understand what you are doing.......
What you want to do is defined the "Return Path" or "Mail From" field for
the SMTP state that defines the sender address (not the author address) as
the return path for any notification (bounce) purposes.
So if you can, set the Return Path (MAIL FROM) in CDONTS, prepare a real
address that will bounce mail to a specific bin. I don't use CDON'T so I
can't tell you how to do that, but it is PART of the normal SMTP system.
This would be the MAIL FROM address in the SMTP state machine:
connection
HELO client domain name
MAIL FROM: return address
RCPT TO: recipient address
DATA
email body
QUIT
It is not the RFC 822 header fields "From: " or "Reply-To:" These are
completely meaningless when it comes to the transport system. Those are
"user fields." Reply-To: just tells the user where to send a reply to. It
is not used for bouncing mail.
Once you do this, then you can use some IIS Event hook to trigger inbound
mail handling for a specific address.
--
Hector Santos
WINSERVER "Wildcat! Interactive Net Server"
support: http://www.winserver.com
sales: http://www.santronics.com
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
"From:
> server@.myserver.com", it has a "Reply To: ourcustomer@.thieremail.com" that
> is the user we are sending on behalf of, so to speak.
> I need to process undeliverable emails (bounced email is the term yes?).
> Looking for suggestions, using ASP or SQL is preferred.
> Thanks,
> Dan Foxley
>|||Hi
CDONTS and the processing of SMTP mail is not really anything to do with SQL
Server. Creating unique return addresses should not be that difficult, but
handled the returned emails is a funtion of your mail server. I think would
still have to parse the content of the email to try and determine why it was
returned.
John
"Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
news:OQeJJk55EHA.3472@.TK2MSFTNGP09.phx.gbl...
> This seems like the solution. I've heard of VERP Variable Envelope Return
> Path, mainly used in the Unix world for prepending each email recipient
> with a unique "From:", have you seem implementations using SQL?
> Thanks,
> Dan
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23s2NQ3x5EHA.3472@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> SQLMail can be configured to use a non-exchange email account, but I have
>> never done it. Looking at CDONTS you can access a SMTP login (logonSMTP)
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_denali_session_object_cdonts_library_.asp
>> and from there access the inbox and messages within it.
>> John
>> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
>> news:%23hUyOZu5EHA.4040@.TK2MSFTNGP14.phx.gbl...
>> Are there options to using SQL Mail without an Exchange server? Looks
>> like SQLiMail in SQL 2005 will not use a MAPI client.
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:OrhAbMt5EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> If you are not returning the emails to a profile that is set up so that
>> SQL Server can read the mailbox then you can not do it from SQL Server.
>> If you can access the emails using SQL Mail, then you may be able to
>> read then with xp_readmail and parse and process them accordingly,
>> unfortunately you may have to deal with a multitude of formats.
>> John
>> "Dan Foxley" <dfoxley@.nospampacificdatavision.com> wrote in message
>> news:uwL30Ls5EHA.1524@.TK2MSFTNGP09.phx.gbl...
>> We use CDonts to send email from SQL 2k & IIS 6.0. All the email is
>> "From: server@.myserver.com", it has a "Reply To:
>> ourcustomer@.thieremail.com" that is the user we are sending on behalf
>> of, so to speak.
>> I need to process undeliverable emails (bounced email is the term
>> yes?). Looking for suggestions, using ASP or SQL is preferred.
>> Thanks,
>> Dan Foxley
>>
>>
>>
>