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