xp_sendmail @message 1

[daglugub37]

How do I control the format of message with xp_sendmail?

In particular how can I specify to start a new line.

I thought it was something like this but it is not working for me.

@message = ''message line 1''
@message = @messgae + ''message line 2''

 

[jabrony76]

Use Carriage Returns (Char(13))

Declare @Msg varchar(100)
Set @Msg = 'Line 1' + Char(10) + 'Line 2' 

exec xp_sendmail 'joeblow@biteme.com', @message = @Msg

 

[daglugub37]

perfect, thanks...awesome sample email address