Hi Again,

This is my last question I promise,

I have finished my project almost but I was wanting to know I'm setting up a macro which I hope will just send that one sheet in an email not as an attachment.

is there any code that someone knows or how I can do this.

thanks again for you all help