Sending mails from SQL Server 2005

abhishekkashyap27 · May 5th, 2009, 08:38 AM

Hi All

I am trying to send mail through SQL Server 2005. I have configured the database for this and it works fine.

Here is the code :

Code:

EXEC msdb.dbo.sp_send_dbmail 
@recipients =@Email,
@subject ='New Alert',
@copy_recipients = @HEmail,
@importance ='High',
@body = @MailBody,
@body_format ='HTML';

In the @copy_recipients i have a parameter @HEmail which contains list of email id's with comma separated. e.g. like this - [email protected],[email protected],[email protected]
The problem is it is sending the mail with the first email only i.e [email protected] and the rest is ignored. How to solve this???
Also how to concatenate one email id like [email protected] with a paramter.
Please help....

-- Abhishek

om_prakash · May 11th, 2009, 01:52 PM

Use semicolon to separate emails:
[email protected];[email protected];[email protected]
http://msdn.microsoft.com/en-us/library/ms190307.aspx