Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 DatabaseMail

Author  Topic 

pradeep_iete
Yak Posting Veteran

84 Posts

Posted - 2008-06-11 : 09:08:09
We have this SP to dash off our mail through Datbase
How can we send mails to multiple recipients that is multiple emailsIDs

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Administrator Desk’,
@recipients = 'abc.efg@hotmail.com''efg@hotmail.com',
@body =’’,
@subject = '’;

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-06-11 : 09:11:44
Just add them all to your @recipients variable seperated by a ;
Go to Top of Page
   

- Advertisement -