Works Perfectly! You sir are an expert )), Thank you so much, I have been pulling my hair out for 3 days trying to get this to work. One last thing,
I would like to add a "NAMED_RANGE" from a sheet called "DATA" to show in the Body of that email. Can this be done easily?

I would like this to show in the body of the email, the "Named_Range" actual range is below,

- Sheets("DATA").Range("C8:AN42").Value



Thanks again Georgiboy, great help,

have a great day!