PING: Excel Gurus

[Raven Hawk]

Is their a way to send a single tab in a worksheet to an e-mail address. Imagine that you have this:

Tab1 - Sales
Tab2 - Marketing
Tab3 - Operations
Tab4 - Finance
. . .
Tab 17 - Human Resources

I want to be able to sent each of the tabs to a different e-mail recipient without cutting and pasting. Is this possible? I couldn't find anything in the MS help file on doing this, so I thought that I'd try the experts here as a last resort.

Thanks!

[Farrah Whitworth-Rahn]

Originally Posted by Raven Hawk

Is their a way to send a single tab in a worksheet to an e-mail address. Imagine that you have this:

Tab1 - Sales
Tab2 - Marketing
Tab3 - Operations
Tab4 - Finance
. . .
Tab 17 - Human Resources

I want to be able to sent each of the tabs to a different e-mail recipient without cutting and pasting. Is this possible? I couldn't find anything in the MS help file on doing this, so I thought that I'd try the experts here as a last resort.

Thanks!

Export the tab into a new file, and then email that file.

[finketr]

Originally Posted by Farrah Whitworth-Rahn

Export the tab into a new file, and then email that file.

that's what i was thinking of.. except that feels like a cut&paste which he didn't want to do.

[gottimd]

Why not write a macro in VBA, to select sheet, copy and paste into a new book, and save as the sheets name. Then cycle through all the sheets with the same thing. You can either record a new macro that way, or write it from scratch.

You should also check out Mr Excels Message Board to answer any in depth Excel/Access questions. Its a free board.

[Raven Hawk]

Thanks guys.