Wow.. Really.

I have never been able to get xp_Sendmail to actually send HTML formatted text as an HTML Email.

Maybe Outlook (Exchange Server driven) doesn't like receiving html text, but...

Thank you for your reply.

But unfortunattly, the problem is not using xp_sendmail

it is that I am attempting to send HTML formatted Email and xp_sendmail will not do that for me.

I...

would it help if you did this:

SELECT Name, Surname, (Max(Id) + 1) as ID

FROM Employees

This would aleays give you 1 + your max value in the table..

Or have you tried...

A note on NULL's

NPeeters above commented on concatenating null values.

When building strings on the fly in a select statement, a null value in any one of the returned fields will...