Mail a single sheet wo code

[santhoshlk]

Hi Excellers.. pls help me..\\

I have a work book contains with multtiple sheets and need to mail (as attachement) only s single sheet in Excel 2007-2010. with out using macros or vba code... pls help me. Iam using MS Offcie outlook

thanks

 

[Peter_SSs]

As far as I am aware there isn't a built-in option to email a single sheet. Therefore, if you are not going to use vba, you would need to save a copy of your workbook, delete all the other sheets, then email that workbook.