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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy