How to send an email to multiple recipients ?
<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>