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.
| Author |
Topic |
|
whitmoj
Yak Posting Veteran
68 Posts |
 Posted - 2010-09-01 : 06:03:30
|
| I have a table in my DB that contains 2 rows Names and email address's. I am looking at writing a Stored Procedure that uses the emails in the table and sends a bulk email. Any help would be appreciated.WhitmojIf I have inspired one person today then my job is done. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-09-01 : 13:04:51
|
| you can use sp_send_dbmail system procedure for that. Get list of email addresses in a variable asSET @emaillist=STUFF((SELECT ';' + email FROM YourTable FOR XML PATH('')),1,1,'')then pass this @emaillist as a parameter for procedure------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Bulk email