title: How to send an email to multiple recipients ?
body: <p>I have a stored procedure which sent emails to few recipients. In this I want to send to two differet recipients using <strong><em>@copy_recipients</em></strong>. But I get a syntax error. How to make this work?        </p>
  
  <p><strong>stored procedure code</strong>      </p>
  
  <pre><code>EXEC msdb.dbo.sp_send_dbmail
      @profile_name = 'mail', 
      @recipients = @Mail1,
      @copy_recipients = @Mail2;@Mail3, 
      @body =@body ,
      @subject =@subject 
  </code></pre>