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
 Transact-SQL (2000)
 sp_send_cdosysmail

Author  Topic 

billsox
Yak Posting Veteran

74 Posts

Posted - 2005-02-03 : 09:14:27
Hi -- I'm using the sp_send_cdosysmail stored procedure as recommended by Microsoft (http://support.microsoft.com/default.aspx?scid=kb;en-us;312839). This sproc is able to send mail but all of the carriage returns/line feed characters in the body do not display in the resulting email. Thus, the resulting email is almost unreadable. I'm certain that those characters are in the body as the text I'm sending looks fine when I write it to the Query Analyzer results window. Any idea what might be wrong? Is it an Outlook issue?

Confused,

Bill

billsox
Yak Posting Veteran

74 Posts

Posted - 2005-02-03 : 09:24:35
Never mind. I figured it out. Outlook has a setting called "Unwrap Text" which was set to true. Setting it to false made the text display properly.

Bill
Go to Top of Page
   

- Advertisement -