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 |
|
zezu10
Starting Member
3 Posts |
 Posted - 2009-01-26 : 11:15:51
|
| Hi guys.I have a problem where I would like to generate a list of email addresses and then fire out a basic email to all of them, I'm just wondering how easy this is?I have previously sent one off emails using a stored proc called dbo.xp_smtp_sendmail and have also used VB to do this but never from a random list which I'm guessing would have to pass a variable which is the email address through it.Anyone got any ideas? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-01-26 : 13:24:01
|
| If "random" comes anywhere close in our understanding of the word "spam", I can't see this getting any assitance here. You'll have to provide some more inforamtion/credentials to persuade us that this isn't a bad idea in the first place. |
 |
|
|
zezu10
Starting Member
3 Posts |
Posted - 2009-01-27 : 04:48:46
|
| LOL ok.I have a list of season ticket holders for an attraction at my company and we are looking to send them an email when their season ticket expires.Therefore I want to pull everyone from a table who has an expired ST, and then email then asking them to renew. |
|
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2009-01-27 : 17:14:38
|
| Could you create a stored procedure to do something like this:1. Store emails in a temp table2. Loop through temp table, sending out emails one by one |
|
|
|
|
|
|
Automated Email?