[dba-SQLServer]Have SS7 send out e-mails where recipients are retrieved from a table

Francisco H Tapia my.lists at verizon.net
Thu Jul 24 10:57:19 CDT 2003


you can email this out... you can either use Blat or CDO's or SqlMail, I use
blat.  Check books online for the SqlMail Method and
www.sqlservercentral.com has scripts for doing this via CDO's (the
registration is free and the only mail the send you is their newsletter w/
articles and a ton of useful hints and tips).

If you'd like to try your hand at using blat (which is a command line smtp
email client) let me know and I'll post that script.

oh, before I forget you'll also have to step through your output so look up
cursors as well, and be careful to leave them open, always explicitly
deallocate them when you're done.


-Francisco
http://rcm.netfirms.com

On Thursday, July 24, 2003 8:49 AM [GMT-8],
Joe Rojas <JRojas at tnco-inc.com> wrote:

: Hi All,
:
: I have a stored procedure that returns users with their e-mail
: addresses that need to perform a task.
: I would like to know if there is some way to have SS7 use this
: recordset internally to send an E-Mail to each of the people in the
: recordset.
: To top it off, I would like SS7 to perform this take at scheduled
: intervals.
:
: Any suggestions?
:
: Thanks!
: Joe R.
:
:
:
:
: This electronic transmission is strictly confidential to TNCO, Inc.
: and intended solely for the addressee. It may contain information
: which is covered by legal, professional, or other privileges. If you
: are not the intended addressee, or someone authorized by the intended
: addressee to receive transmissions on behalf of the addressee, you
: must not retain, disclose in any form, copy, or take any action in
: reliance on this transmission. If you have received this transmission
: in error, please notify the sender as soon as possible and destroy
: this message. While TNCO, Inc. uses virus protection, the recipient
: should check this email and any attachments for the presence of
: viruses. TNCO, Inc. accepts no liability for any damage caused by any
: virus transmitted by this email.
: _______________________________________________
: dba-SQLServer mailing list
: dba-SQLServer at databaseadvisors.com
: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
: http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list