ex_sendmail function problem

  • kenari7302

    SSC Veteran

    Points: 250

    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

  • David Benoit

    SSC-Dedicated

    Points: 34562

    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

  • kenari7302

    SSC Veteran

    Points: 250

    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

    kenari7305@yahoo.com

    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.com

    Other 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