I am using sp_send_dbmail to send emails from SQL Server 2005. The problem is
that if I have 2 recipients, then each recipient gets the email twice. If I
have 3 recipients, then each recipient gets the email 3 times. And so on.

This is the code I'm running...

exec MSDB..sp_send_dbmail
@profile_name='Craig Profile',
@recipients='cr***@email.com;angeli***@email.com;ge***@email.com',
@subject='test email',
@body='email body',
@body_format = 'TEXT'

....and from that Angelique, Gemma and I will each get this email 3 times. I
have tried changing from TEXT to HTML, and passing some recipients into the
@copy_recipients parameter, but that does not help.

- Craig

How To incorporate table-valued function in Common Table Expressio
Getting 10 Records the Fastest Way Possible // ROWLOCK, UPDLOCK, READPAST
Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
JOIN Question...