Formatting the result in xp_sendmail

• Priti

  Old Hand

  Points: 376

  More actions

  November 16, 2001 at 11:46 am

  #158010

  Hello,

  I'm using xp_sendmail in the sp and in @query I do select * from table1.

  The result also pages me.

  The formate is not at all readable and even if @attach_results = 'TRUE'

  In the text file its not formatted as it sends mail to my manager I want it to be formatted and looks good. Can anyone help me or Is there any way to get the results in readable format.

  Thanks in Advance for the help

  Priti

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738357

  More actions

  November 19, 2001 at 7:45 pm

  #420224

  You have to manually format it. You can use a table to do this or a complex select statement. If you post what you want, we can try to help )include the DDL for the table).

  Steve Jones

  steve@dkranch.net