title: How can we send email with an attachment to 500 people using SQL Server (SSIS, SSRS or SQL AGENT)
body: <p>I need your advice. How can we send email with an attachment to 500 users. We are using SQL Server 2008 R2 Enterprise edition in our company.</p>
  
  <p>I had tried using the <code>Send Mail</code> task from SSIS, but seems we can send maximum of 18 recipients due to the constraint in <code>To: Cc: Bcc:</code>.</p>
  
  <p>Is there any way we can send using SQL Agent or SSRS ??</p>
  
  <p>I have another doubt regarding SSRS report subscription recipients. </p>
  
  <p>To how many maximum number of recipients we can send report using subscription. The reason i am asking this second is if i can send a report to 500 users by using SSRS report subscription then i can use SSRS.</p>
  
  <p>Thanks for your time!! </p>