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.

Simon

[Back to original message]