XP_SendMail error handling

• Chris Watson-180569

  Grasshopper

  Points: 17

  More actions

  October 11, 2004 at 4:18 pm

  #86638

  Hi,

  Does anyone know how to handle errors such as "ambiguous recipient" and the like in SQL so I can handle it in the stored procedure calling XP_SendMail... The trouble is I can't handle it in the ASP I'm writing because I have to use a corporate standard dll to connect to the database which doesn'thave any erro handling capabilities... I know, office politics, believe me!

  Any suggestions most welcome.

  Thanks,

  Chris

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  October 11, 2004 at 5:32 pm

  #526267

  If you are using Excahnge Server, then one way is to use CDO to check for the existence of a mail box before you execute xp_sendmail.

  CDO stands for Colaborative Data Objects. This is the object model used to tap into your Exchange Server.

  ---

  Kindest Regards,