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

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


--
darkwood
------------------------------------------------------------------------
darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=496468

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.

"darkwood" wrote:


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


--
darkwood
------------------------------------------------------------------------
darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=496468

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!
--
mac


"widman" wrote:

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.

"darkwood" wrote:


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


--
darkwood
------------------------------------------------------------------------
darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=496468