|
|
You're in the
iis smtp nntp
group:Handling Bounced Emails
iis smtp nntp:
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. [quoted text, click to view] "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
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 [quoted text, click to view] "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 [quoted text, click to view] "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 [quoted text, click to view] "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 [quoted text, click to view] "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 [quoted text, click to view] "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 >>>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |