Use sp_send_dbmail to send newsletter to 15,000 recipients?

• Andy Holliday

  SSC Enthusiast

  Points: 174

  More actions

  September 17, 2008 at 7:11 am

  #382682

  Hello,

  I have set up sp_send_dbmail to send me a newsletter at a test. I would now like it to send out to the 15,000 registered recipients I have in one of my SQL 2005 tables.

  Is there a way of using sp_send_dbmail to send to multiple recipients in the stored procedure?

  Would sp_send_dbmail be the most efficient way of doing it?

  Thanks!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 728164

  More actions

  September 17, 2008 at 7:58 am

  #873016

  You can (I believe) separate addresses with semicolons, but I'm not sure you want to do this.

  Likely you want some loop or process that sends xxx at a time, and tracks the sends.

  http://msdn.microsoft.com/en-us/library/ms190307.aspx

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com