XP_Sendmail

• scottsanpedro

  SSCrazy

  Points: 2130

  More actions

  February 5, 2003 at 4:05 am

  #80276

  I'm trying to set up a daily job and send lists of our members to certain staff each day so they can carry out jobs on them.

  Trouble is I either want the mail to attached the list in MS EXCEL or even organise the .txt output to be better formatted. Currently the title goes to the full varchar size set on the table.

  Any ideas would be gratefully accepted

  Cheers

  Scott

• sjcsystems

  Ten Centuries

  Points: 1347

  More actions

  February 5, 2003 at 4:10 am

  #448069

  Well one quick answer would be to use SUBSTRING(), or LEFT() in your SELECT statement to truncate the data you select.