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)
 SQL XP_SENDMAIL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-08-16 : 08:49:49
Steve writes "I am trying to have the server send an email to a recipient with a request to set up a new vendor in their system.

It is a fairly long email and I am using the SQL books suggestion to load the message into a text field and do a query.

It works great accept the lines on the email seem to carriage return at wierd times. I set the @width parameter to 250 which made it a bit better but a lot of the text either runs together or splits a line.

How can I control the carriage return in the text message?"
   

- Advertisement -