I use xp_smtp_sendmail to send e-mail messages with attached files on a monthly basis via a scheduled dts package within SQL 2000. I can successfully send to individuals (i.e. email@example.com), however, if I try to send to a group I am not successful. Even when I use the SMTP address for that group (i.e. IT@company.com is the SMTP address for the Information Technology mail group). The message will not send even though the return code returns success. Included is the SQL statement contained in the execute sql task of the
Does anyone have any suggestions? Thanks.
declare @rc int,
@Month AS CHAR(2),
@Year AS CHAR(4),
@Message_Text AS CHAR(500)
SET @Month = MONTH(DATEADD(M,1,GETDATE()))
SET @Year = YEAR(DATEADD(M,1,GETDATE()))
SET @Message_Text = 'This is only a test.'
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'DoNotReply@tfsi1.com',
@FROM_NAME = N'TFS Information Systems',
@TO = N'IT@tfsi1.com',
@priority = N'HIGH',
@subject = N'This is a Test',
@message = @Message_Text,
@type = N'text/plain',
@server = N'TFSMAIL'
RC = @rc