xp_sendmail problem - body message breaking onto new line..

[vic y]

Created a SP that uses system function XP_SENDMAIL. I want
to be able to send a HYPERLINK in the email. The
HYPERLINK is created dynamically and generally long in length (exceeds
default width of 80 characters) and when rendered in the email is split
across 2 lines. The problem is that when you click on the link it
disregards the part of the link that has been split onto the line
below.

Does anyone know a solution to this - how to extend the width of the
email to wider that 80 characters so that the link is not split over 2
lines? I know that you can use the @width parameter when placing the
message in an attatchment, however I want the link to be placed in the
body of the email and not in an attachment.

Any help is much appreciated..

[Simon Hayes]

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

[vic y]

Thanks Simon for your advice, will look into this .