07-25-2005, 02:52 PM | #1 | ||
College Starter
Join Date: Mar 2002
Location: Thunderdome
|
PING: Excel Gurus
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! |
||
07-25-2005, 03:02 PM | #2 | |
Red-Headed Vixen
Join Date: Oct 2003
Location: Phoenix, AZ
|
Quote:
Export the tab into a new file, and then email that file. |
|
07-25-2005, 03:23 PM | #3 | |
College Prospect
Join Date: Jan 2005
Location: Inland Empire, PRC
|
Quote:
that's what i was thinking of.. except that feels like a cut&paste which he didn't want to do. |
|
07-25-2005, 03:26 PM | #4 |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
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.
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
07-25-2005, 04:18 PM | #5 |
College Starter
Join Date: Mar 2002
Location: Thunderdome
|
Thanks guys.
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|