microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Email confirmation? Bounced email? What to do?

Subject: Re: Email confirmation? Bounced email? What to do?
From: Joe Webb
Date: Tue, 13 Dec 2005 08:33:17 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Since it's rather straightforward and doesn't involve matching rules,
etc, I'd go with Database Mail for the initial confirmation emails. 

HTH...

-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)



On 13 Dec 2005 06:00:34 -0800, [email protected] wrote:

>I get the concept of that.  However, I'm mainly wondering how to
>automate the confirmation emails?  Do I just treat that as a separate
>notification rule/event or something?   Or maybe just use plain
>"Database Mail" for the initial confirmation email?  And then once
>they're enabled, kick in with NS email?
>
>
>Joe Webb wrote:
>> The URL in the email could be something like:
>>
>> http://www.mycompany.com?uid=subscriberid
>>
>> When the user clicks on the link, it would take them to a site that
>> would read the querystring parameter and ask the user if they'd really
>> like to subscribe. If they click yes, then you enable the subscriber
>> using the SQLNS api.
>>
>> HTH...
>>
>> --
>> Joe Webb
>> SQL Server MVP
>> http://www.sqlns.com
>>
>>
>> ~~~
>> Get up to speed quickly with SQLNS
>> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
>>
>> I support PASS, the Professional Association for SQL Server.
>> (www.sqlpass.org)
>>
>>
>> On 12 Dec 2005 16:11:19 -0800, [email protected] wrote:
>>
>> >I can see how the subscriber management interface could add them as a
>> >disabled subscriber, but then how to manage the email of the link,
>> >enabling, etc.?  Should I create just another notification application,
>> >just to track & notify new subscribers with their confirmation link?
>> >So for example, I would have one NS instance & two NS applications.
>> >One application is for my actual business need.  The other is simply a
>> >new subscriber app.  The user signs up for a subscription to what they
>> >think is the business app, but behind the scenes, I actually add them
>> >to my "new subscriber" app.  This addition triggers a confirmation
>> >email to the other app.???? Sorry - I'm more of a DB guy, not
>> >applicaiton, or programming.  But I appreciate any help you could
>> >offer.
>> >
>> >My management is mainly concerned about 1) subscriber management & 2)
>> >bandwidth/bad & expired emails
>> >
>> >
>> >
>> >[email protected] wrote:
>> >> By "bad mail drop" do you mean the windows SMTP service?  I'm sending
>> >> this mail out to the same SMTP server that handles all outgoing mail,
>> >> and it's not running on Windows ( I don't believe).  I'm not sure
>> >> there's an interactive way to scan through that SMTP gateway to check
>> >> out that stuff.  And of course we don't want to do it manually.
>> >>
>> >>
>> >> kate wrote:
>> >> > about bad emails. your right that NS does not see this as their
>> >> > problem. but it is a problem that can be dealt with. Assuming all your
>> >> > NS emails have a distinct from mail address (always a good idea for
>> >> > tracking), you can periodically trawl the bad mail drop for emails with
>> >> > this from address. Store the results of that somewhere. when a mailing
>> >> > address gets more than 2 or 3 entries then fire up a function to
>> >> > disable the subscriber and send them an email with a re-enable link
>> >> > just in case it is a blip.
>> >> > 
>> >> > job done.
>> >> > 
>> >> > kate p

<Prev in Thread] Current Thread [Next in Thread>