how can I send only 1 tab to email ?

**alancauchi** · 12-18-2009, 10:05 AM

Hi,

I have a worksheet with lots and lots of tabs in it and they are all colored accordingly. I need to send only one of the tabs by email (not the whole excel file) and it seems that on excel 2007, this cannot be done or better said, it's more hidden and I cannot find it.

Any help please!!!!!!

**DonkeyOte** · 12-18-2009, 10:13 AM

First port of call for any email related questions on XL is ron de bruin's site which has lots of examples from which to choose:

http://www.rondebruin.nl/sendmail.htm

one being:

http://www.rondebruin.nl/mail/folder1/mail2.htm

**alancauchi** · 12-18-2009, 10:31 AM

is it so complicated to send a tab from a whole excel workbook

**ChemistB** · 12-18-2009, 10:47 AM

The code for moving a single tab into email depends on what type of email you have and that makes it more complicated.

A simple alternative would be to copy the tab to a new workbook and send that (right click on the tab and "move or copy").

If you really want it automated, attached is a working example of using VBA (modified from RonBruin's site) and Outlook. Use Alt F11 to open the VBA editor and then double click on "this workbook" in the "Project VBA projects" window to bring up the code.

Hope this helps.

**alancauchi** · 12-21-2009, 09:25 AM

Originally Posted by ChemistB

The code for moving a single tab into email depends on what type of email you have and that makes it more complicated.

A simple alternative would be to copy the tab to a new workbook and send that (right click on the tab and "move or copy").

If you really want it automated, attached is a working example of using VBA (modified from RonBruin's site) and Outlook. Use Alt F11 to open the VBA editor and then double click on "this workbook" in the "Project VBA projects" window to bring up the code.

Hope this helps.

I don't want nothing complicated. I just want to edit the tab on that excel sheet and send that one only not the whole document. it's there something where I right click and "send this sheet only" thing?