xp_sendmail and @recipients

• jwt

  Say Hey Kid

  Points: 668

  More actions

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

• BReuter

  Ten Centuries

  Points: 1325

  More actions

  July 15, 2003 at 3:35 pm

  #465605

  Can you post your exec xp_sendmail statement?

• jwt

  Say Hey Kid

  Points: 668

  More actions

  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

• BReuter

  Ten Centuries

  Points: 1325

  More actions

  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.