Send a Mail In HTML Format With SQL7,0

• gedeon

  SSC Veteran

  Points: 262

  More actions

  October 11, 2002 at 3:52 am

  #80146

  Dear all,

  I would like to send a mail where the email body will be HTML formatted.

  I have already used XP_sendmail but this procedure doesn't allowed this format.

  Is someone as an idea or an experiance in that domain?

  Actually I'm using SQL7,0 with sp3.

  Best regards.

  
  Best regards,
  
  Michael.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  October 11, 2002 at 9:57 am

  #438371

  You'd need to develop a script that will write out the necessary parameters and build the mail from scratch. Or use an ActiveX type object. Persits software has a free one that works well for me.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones