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.
| Author |
Topic |
|
pmalooi
Starting Member
2 Posts |
 Posted - 2002-03-25 : 05:55:38
|
| Got the following problem on SQL 2k:if count(*) = 25 exec xp_sendmail @recipients = 'user', @subject = 'testmessage', @message = 'this is a test message'/*it executes and mail is send, but when @recipients = 'group' statement executes, but no mail is send.any ideas??*/ |
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2002-03-25 : 13:35:52
|
| Try using the smtp Email name instead of the group.i.e.: joe@you.com; Mike@you.com etc... |
 |
|
|
bouno
Starting Member
23 Posts |
Posted - 2002-03-25 : 21:40:57
|
quote:
Got the following problem on SQL 2k:if count(*) = 25 exec xp_sendmail @recipients = 'user', @subject = 'testmessage', @message = 'this is a test message'/*it executes and mail is send, but when @recipients = 'group' statement executes, but no mail is send.any ideas??*/
|
|
|
|
bouno
Starting Member
23 Posts |
Posted - 2002-03-25 : 21:41:14
|
quote:
Got the following problem on SQL 2k:if count(*) = 25 exec xp_sendmail @recipients = 'user', @subject = 'testmessage', @message = 'this is a test message'/*it executes and mail is send, but when @recipients = 'group' statement executes, but no mail is send.any ideas??*/
|
|
|
|
|
|
|
xp_sendmail