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 |
|
benking9987
Posting Yak Master
124 Posts |
 Posted - 2011-12-05 : 11:00:01
|
| I have an SQL 2005 installation and my company also runs MS Exchange 2010. I would like to send out some automated email notifications to customers (anywhere from 200 - 1000 emails per day) notifying them about shipment statuses of their items. The specific time to email the customer and the content to be emailed to the customer will be determined by a SQL query that is pretty basic. The part I need some input on is how to interface this with an email client.Any ideas?Thanks in advance. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-12-05 : 11:17:44
|
| First of all get the emails you want to send into a table - preferably on a dedicated server. Have a column for the sent time in it.Now you can add emails to the table and have a ercord of what has happened. Also means that the email soution only has to interface with that table, it is independent of the rest of the system.How to send emails - depends on what you are comfortable with - you can use an SP and sp_send_dbmail if you wish as you have low volumes.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Email customer list from SQL