January 16, 2002 at 2:39 am
did any one can help me using ex_sendmail function...? I did try to send below statement using query analyzer :-
EXEC xp_sendmail 'wilda',
@subject = 'Query Result: Total Products'
but i received below e-mail message :-
Your message did not reach some or all of the intended recipients.
Subject: Query Result: Total Products
Sent: 1/16/02 5:07 PM
The following recipient(s) could not be reached:
Wilda (E-mail) on 1/16/02 5:07 PM
No transport provider was available for delivery to this recipient.
-------------------------
did anyone can help me..I need it urgently please.
regards,
kenari(kenari7305@yahoo.com
kenari
January 16, 2002 at 9:44 am
Is the wilda account listed a valid email account. If this account is not on your domain, then you should specify the smtp address such as your.name@yourdomain.com
Other than that email address being potentially bad, the rest of the syntax is correct.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 16, 2002 at 6:52 pm
hi david...
is it like this :-
EXEC xp_sendmail 'wilda@pmrdc.com',
@subject = 'Query Result: Total Products'
it still giving me the same error message...
tq
regards,
kenari
quote:
Is the wilda account listed a valid email account. If this account is not on your domain, then you should specify the smtp address such as your.name@yourdomain.comOther than that email address being potentially bad, the rest of the syntax is correct.
Hope this helps.
David
kenari
kenari
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply