Need to send mails in bulk

• narendra.pola

  Valued Member

  Points: 61

  More actions

  May 27, 2009 at 7:18 am

  #132692

  Hi, one and all

  My task is to send a mail to 20k emailids how it can be possible through sql server can u please explain me the process. Is there any limit in sending mails in that format

  Thanks,

  Narenndra.

• CrazyMan

  SSChampion

  Points: 12560

  More actions

  May 27, 2009 at 7:41 am

  #1000581

  Hi

  I am not sure about the limit, one way you can do is to loop through the table that have the mail id 🙂

• narendra.pola

  Valued Member

  Points: 61

  More actions

  May 27, 2009 at 7:44 am

  #1000589

  Even i need the process how mails can be sent through sql server .I am not sure with the process and regarding the setting in sql server agent

• Sakthivel Chidambaram

  SSCertifiable

  Points: 5531

  More actions

  May 27, 2009 at 7:44 am

  #1000590

  Hi,

  Better create a DL in Active Directory and add those mail ID's to that group and send email to that DL Group Name from SQL Server... Exchange server and Active Directory will take care of rest.. Less load on SQL Server..

  Regards,
  Sakthi
  My Blog -> http://www.sqlserverdba.co.cc

• CrazyMan

  SSChampion

  Points: 12560

  More actions

  May 27, 2009 at 7:47 am

  #1000596

  http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm

  check this link out, this says the process of setting up the mail on SQL server

  🙂