how can I send only 1 tab to email ?

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?