how send email from sql server 20005-result of a query including a style sheet by email

• midan1

  SSCertifiable

  Points: 5100

  More actions

  April 7, 2007 at 12:57 pm

  #195008

  how to send email from sql server 2005

  on SMTP

  with-result of a query including a style sheet by email

  HTML like this

  sn		zip	id	email	name
  1
  2
  3......

   

   

   

   

   

   

   

   

   

  tnx 

• MohammedU

  SSCoach

  Points: 19644

  More actions

  April 8, 2007 at 4:00 pm

  #699245

  SQL server 2005 has SMTP mail called database mail check BOL for more details...

  Check body format option in sp_send_dbmail procedure...

  MohammedU
  Microsoft SQL Server MVP