Re: xp_sendmail problem - body message breaking onto new line..
Posted by Simon Hayes on 09/13/05 15:52
You could consider using xp_smtp_sendmail, which is a popular
alternative to xp_sendmail, and doesn't require a MAPI installation -
it's a single extended stored procedure:
http://www.sqldev.net/xp/xpsmtp.htm
According to the docs, it supports lines up to 1000 characters, and you
can specify your own newlines explicitly.