xp_smtp_sendmail

• @DJ

  SSCommitted

  Points: 1989

  More actions

  August 1, 2005 at 2:25 am

  #164380

  Hi

  I am trying to use xp_smtp_sendmail from sqldev.net. Installation was easy but it does not seem to work.

  Tried to run the simplest version like:

  declare @rc int

  exec @rc = master.dbo.xp_smtp_sendmail

      @FROM   = N'MyEmail@MyDomain.com',

      @TO     = N'MyFriend@HisDomain.com'

  select RC = @rc

  if rc = 0 then successfully executed, if rc = 1 then failure and an error meassage.

  When I run I get a 1, but no error message.

  Does anybody have any experince with this?

  Thanks for all help

   

  Regards

  Dan

• @DJ

  SSCommitted

  Points: 1989

  More actions

  August 1, 2005 at 2:35 am

  #578438

  I found the error.

  I can not use the simplest verison, but need to add @server definition.

• ranadip.dey

  Old Hand

  Points: 376

  More actions

  December 1, 2010 at 1:42 am

  #1257193

  If any one need the installation copy of xp_smtp_sendmail, you can email me I have a copy.

  ranadip.dey@gmail.com

  Thanks,