<Send To> multiple sheets

[Guest]

I can send a workbook or a selected sheet to a recipient by pressing
<File><Send To><Mail recipient>...but what if I don't want to send an entire
workbook. Is there a way to send multiple sheets without sending them one at
a time? Thanks in advance for your help!
Steve

 

[darkwood]

This might be a backwards way to do it, but it has been effective for
me:

highlight all desired sheets - right click on one of the sheets - move
or copy -
under- 'to book': select (new book) and then MAKE SURE you click the
check box 'create a copy'.

This will copy all the desired sheets into a new workbook, which you
can then send to your recipient, and promptly delete if you so desire.

Hope that helps

-Scott

 

[Guest]

I use something similar to sent out quotes from a workbook that has costs and
other details. I simple macro copies the sheet, pastes it as values, deletes
the sheet with details, saves it, and emails it as an attachment.

 

[Guest]

How about trying the Free download "ASAP Utilities"?
You can highlight any (one/two/group) sheets - OR ranges of cells on one
work tab - from within one workbook and with ASAP you simply one-click &
create a new workbook (i.e. with JUST those items that you want copied).
Then send THAT version.
Works for me!