Post reply

Formating Email Body sent with xp_sendmail

  • April 13, 2006 at 7:47 am

    #167692

    Hi,

    I'm using xp_sendmail to send automatically emails from SQL Server 2000, regarding different status from the main database.

    Is there a way to format the email body so that it looks more friendly? Like breaklines / hyperlinks / bold ???

    Thank you

  • April 13, 2006 at 8:17 am

    #632400

    I found that char(13) is going to create a break line.

    Any other formatting options?

  • April 13, 2006 at 9:21 am

    #632437

    If you want hyperlinks, you need to include the entire HTML, meaning the <HTML><HEAD></HEAD><BODY> etc. tags in the message.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply