I need to send via e-mail only one sheet from excel workbook. It looks easy but it proved to be ral nightmare for me. When I write e-mail and choose file to attach, I always attach the whole workbook and I can not see any option you attach only one sheet. I would really appreciate if you could explain to me how to attach only one sheet.
If recipient of your e-mail can receive HTML mails then you can copy desired sheet directly to e-mail message. If you want to collaborate with this sheet then the first thing I suggested is not a good option. To send only one sheet you will have to send e-mail message from Excel. On the Standard toolbar, click the e-mail button. Enter address, subject and usual things. To attach sheet click on Insert File and choose file you wish to insert. There will be menu with options. Set these options to send only one sheet instead whole workbook. And this solves your problem.