In SQL 7.0, you need to setup Outlook 98 for SQLMail.
Becasue we are using MailSite, we set up a couple of ODBC mailing lists for
our users and schedule jobs every morning to send notice to the user which
going to be expired.
Regards,
Dan Tang
Network Operation
Domain Internet Access
---------------------------------------------------
Sign Up a Dial up account at http://isp.dmn.com.au and get connect right
now.
---------------------------------------------------
Join the Emerald ASP Addon Product mailing list
by sending email to emerald-request@dmn.com.au with message body SUBSCRIBE
only
-----Original Message-----
From: Alexander Blauvelt <online@olg.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Thursday, June 10, 1999 10:59 PM
Subject: Re: [Emerald] rebatch behind the scenes .... ?
>We\'re still using sql server 6.5 and probably will for some time yet.
Will
>this script work on version 6.5 ?
>
>Thanks,
>Alex Blauvelt
>Online Gateway, Inc.
>
>
>Quoting Dan Tang <dan@dmn.com.au>:
>
>> Sorry, there is minor error on the @MsgBody, the coorect one should be:
>>
>> declare curMailer INSENSITIVE cursor
>> for select email,firstname,lastname
>> from subaccounts
>> where datalength(email)>0
>> declare @email varchar(50)
>> declare @FirstName varchar(50)
>> declare @lastName varchar(50)
>> declare @MsgBody varchar(2000)
>>
>> open curMailer
>> fetch next from curMailer into @email,@firstname,@Lastname
>> while @@FETCH_STATUS=0
>> begin
>> Select @MsgBody=\'Dear \' + @FirstName + \' \' + @LastName + \',\' +
>> char(13)
>> select @MsgBody=@MsgBody + \'Your main message here\' + char(13) +
>> char(13)
>> select @MsgBody=@MsgBody + \'Regards,\'+ char(13) + char(13)
>> select @MsgBody=@MsgBody + \'Your title\'
>> exec master..xp_sendmail @recipients=@email,
>> @subject=\'Your
>> subject\',
>> @Message=@MsgBody
>> fetch next from curMailer into @email,@firstname,@Lastname
>> end
>> close curMailer
>> deallocate curMailer
>>
>>
>>
>>
>> Regards,
>>
>> Dan Tang
>> Network Operation
>> Domain Internet Access
>> ---------------------------------------------------
>> Sign Up a Dial up account at http://isp.dmn.com.au and get connect right
>> now.
>> ---------------------------------------------------
>> Join the Emerald ASP Addon Product mailing list
>> by sending email to emerald-request@dmn.com.au with message body
SUBSCRIBE
>> only
>>
>>
>> -----Original Message-----
>> From: Dan Tang <dan@dmn.com.au>
>> To: emerald@iea-software.com <emerald@iea-software.com>
>> Date: Thursday, June 10, 1999 9:30 AM
>> Subject: Re: [Emerald] rebatch behind the scenes .... ?
>>
>>
>> >A store procedure in SQL 7.0 for you
>> >
>> >declare curMailer INSENSITIVE cursor
>> > for select email,firstname,lastname
>> > from subaccounts
>> > where datalength(email)>0
>> >declare @email varchar(50)
>> >declare @FirstName varchar(50)
>> >declare @lastName varchar(50)
>> >declare @MsgBody varchar(2000)
>> >
>> >open curMailer
>> >fetch next from curMailer into @email,@firstname,@Lastname
>> >while @@FETCH_STATUS=0
>> >begin
>> > Select @MsgBody=\'Dear \' + @FirstName + \' \' + @LastName + \',\'
+
>> char(13)
>> > select @MsgBody=\'Your main message here\' + char(13) + char(13)
>> > select @MsgBody=\'Regards,\'+ char(13) + char(13)
>> > select @MsgBody=\'Your title\'
>> > exec master..xp_sendmail @recipients=@email,
>> > @subject=\'Your
>> subject\',
>> > @Message=@MsgBody
>> > fetch next from curMailer into @email,@firstname,@Lastname
>> >end
>> >close curMailer
>> >deallocate curMailer
>> >
>> >
>> >
>> >To test it, run this on SQL7.0 QueryAnalyzer, replace @email the
>> >@receipients=@email with your email address like that
>> >\'yourmail@yourdomain.com\'.
>> >
>> >Because this is a store procedure, you can acctually set up a ASP page,
>> >which you can type in the message and let the Web Server and SQL 7.0
>> handle
>> >the rest.
>> >
>> >
>> >Regards,
>> >
>> >Dan Tang
>> >Network Operation
>> >Domain Internet Access
>> >---------------------------------------------------
>> >Sign Up a Dial up account at http://isp.dmn.com.au and get connect
right
>> >now.
>> >---------------------------------------------------
>> >Join the Emerald ASP Addon Product mailing list
>> >by sending email to emerald-request@dmn.com.au with message body
SUBSCRIBE
>> >only
>> >
>> >
>> >-----Original Message-----
>> >From: Alexander Blauvelt <online@olg.com>
>> >To: emerald@iea-software.com <emerald@iea-software.com>
>> >Date: Wednesday, June 09, 1999 11:40 PM
>> >Subject: Re: [Emerald] rebatch behind the scenes .... ?
>> >
>> >
>> >>> Might I suggest if this is to happen that it\'s not a feature enabled
by
>> >>> default :^)
>> >>>
>> >>> Most banks would at best kick you up the ass for \"guessing\" CC
expiry
>> >dates,
>> >>> and some will withdraw merchant facilities...
>> >>
>> >>OUCH. That i didn\'t know. Perhaps we could have a script that
>> >>emailed the customer to please call with new credit card information.
>> >>Unfortunately I don\'t know enough about sql server and scripting to be
>> >>able to do this. Anyone have an idea on how this could be done ?
>> >>
>> >>
>> >>Alex
>> >>Online Gateway
>> >>
>> >
>>
>>
>