Post reply

xp_sendmail and @recipients

  • July 14, 2003 at 9:44 am

    #81197

    Has anyone run into a problem using xp_sendmail where it retuns the error 'xp_sendmail requies one or more @recipients'. My SQL does have @recipients and the email is sent to them successfully - but I still get an error message.

    Normally I wouldn't worry about it, but the error message is causing my DTS package to fail - and that is frustrating.....

  • July 15, 2003 at 3:35 pm

    #465605

    Can you post your exec xp_sendmail statement?

  • July 16, 2003 at 11:45 am

    #465706

    Sure

    SET @MailMsg = '78 load ran correctly'

    -- Actually this is built dynamically in a

    --case satement, and is only one of the

    --possible results for the mail message

    EXEC master.dbo.xp_sendmail

    @recipients = 'TomN.@myco.com; TomS@myco.com',

    @message = @MailMsg ,

    @copy_recipients = 'JWT@myco.com'

    @subject = 'Daily 78 Load'

    Edited by - jwt on 07/16/2003 1:44:38 PM

  • July 16, 2003 at 3:26 pm

    #465754

    Are sure that @MailMsg isn't null or something strange like that? Might be worth trying to reapply the service pack if the dll containing xp_sendmail depends on others that are of a different version.

    I have worked around some other SQL mail inconsistancy by always issuing a

    exec master.dbo.xp_startmail, but I doubt that will help here.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply