msdb.dbo.Sp_send_dbmail issues related to the width of the email

• BaldingLoopMan

  SSCertifiable

  Points: 6378

  More actions

  June 21, 2010 at 2:07 pm

  #223013

  I have the @query_result_width = 32761. It appears in the email as it appears below. Is there a way to have the output of the query in the email scrollable so that it doesn't wrap?

  OfferId OfferName TeleDGA Live CoregList SiteReg Email LeadDelivery ConfLetter Total TeleDGA Live CoregList SiteReg Email LeadDelivery ConfLetter Total AttGenPercent

  ----------- ---------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ----------- ----------- ------------ ----------- ----------- ----------- ----------- ----------- ----------- ----------- ------------ ----------- ----------- -------------

  2 American 0 0 5529 220 0 0 37 5786 0 0 5507 162 0 0 10 5679 98

• Eralper

  SSCarpal Tunnel

  Points: 4438

  More actions

  June 22, 2010 at 12:38 am

  #1183097

  Hi,

  I think this is not an HTML formatted email.

  Perhaps if you can set email format to HTML, you can control it better.

  You can check SQL Server Database Mail sp_send_dbmail Example

  You will set the @body_format = 'HTML' for html emails.

  I hope that helps,

  Eralper
  SQL Server and T-SQL Tutorials and Articles
  Microsoft Certification and Certification Exams