Link to home
Start Free TrialLog in
Avatar of Glen_D
Glen_D

asked on

Email sent to multiple recipients using dbmail in SQL Server 2008

Hello...can send to one user with no problem; how to I add additional email addresses to send to multiple users from the single email.  Thx

USE msdb
GO
EXEC sp_send_dbmail @profile_name='ERICAProfile',
@recipients='test@user.com, jb@acme.com',
@subject='Test message',
@body='This is the body of the test message to test for multiple email accounts on the message.
Test 4 - Congrates Database Mail Received By you Successfully.'
ASKER CERTIFIED SOLUTION
Avatar of dqmq
dqmq
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial