Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Send Multiple Emails -- HELP

Author  Topic 

cindylee
Yak Posting Veteran

55 Posts

Posted - 2004-12-05 : 23:15:12
Hi,
As an end of day process we have to send emails to mutilple clients. All the information(To address,Subject information, Text information) are stored in a temp table. I want to loop through all the records and send email. I can able to loop through all records using Global Variable and Activex scripts but iam stuck with sending emails to each record while iam in the loop.
any help or better suggestion is very much appreciated..

Cindy

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-12-06 : 00:04:14
Hi Cindy

Have you read this ? http://www.sqlteam.com/item.asp?ItemID=5908
Does it help ?


Damian
Go to Top of Page

cindylee
Yak Posting Veteran

55 Posts

Posted - 2004-12-06 : 18:32:04
Hi damian,
Thanks for the info, its very helpful.

Cindy
Go to Top of Page
   

- Advertisement -