Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 xp_sendmail output width

Author  Topic 

OwnedByTheMan
Starting Member

35 Posts

Posted - 2001-03-10 : 13:33:23
Is there a way to control the width of the email output from xp_sendmail? My messages wrap at 76 characters. I need around 85 to support a URL that cannot be wrapped. I am using Outlook 2000 as the MAPI server and every other aspect of the mail run performs fine. The "width" parameter, as described in BOL, is to size the output from an included @query parameter but I want to control the width of the output email in total, including the @message block.

I noticed that the Outlook 2000 on my non-development machine has an area under Tools|Options|Mail Format called message format that has a button called settings that lets me adjust the output width of email sent. The SQL box instance of Outlook 2000, used for the xp_sendmail run, has no Settings button. (My SQL box Outlook is set for Network mail as opposed to Internet mail on the other machine so I also went into Control Panel|Mail and looked around in there but didn't see anything of interest.)

Can I control this? If so, how?

--Doug

   

- Advertisement -