I've got it all working now but I want to make sure I have everything 100% before I post the final code. I removed all the kludge that referred...

Here's what I changed to get the formatting on the table just right:

+ CAST(( SELECT

td = [Run...

Thank you. Yes, I actually tried that and I got an email. Now I am just trying to get it formatted because it looks like this:

,td=[Run Time],

,td=[Step ID],

,.

.

.

.

then a...

Hi again Lutz,

When I ran the sproc I got this message:

Msg 8145, Level 16, State 1, Procedure sp_send_dbmail, Line 0

@database_name is not a parameter for procedure sp_send_dbmail.

It doesn't like that...

Thanks Lutz! I will get going on getting it to work with your very helpful input. Yes, you caught me.. I had the PRINT statements commented out...

Thanks for the detailed and fast reply Lutz! I have just started writing stored procedures. I have programmed some in other languages a bit. I will want...

Lutz has suggested a stored procedure but I don't know exactly what he means or what I would be replacing with a sproc. I am too much of a beginner...

Thanks Lutz. My first reply ever. How do I do that please?