Yea i have originally done this Terry, thought there was something else i might have missed.  No problems i will persevere with it and attempt to sort.

Many Thanks again for...

Terry many thanks as i almost have this working now.  I am struggling to get the StepName to appear in the following line:

select @MSG = 'Dear User,' + char(13)...

Terry, you are a legend (not in the old sense as i dont know you )

Thanks Craig

Apologies Terry as I am new to all of this, how or where can I create a global variable?!

Thanks in advance

Craig