Post reply

Formatting the result in xp_sendmail

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply