<Send To multiple sheets
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 |
<Send To multiple sheets
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 |
<Send To multiple sheets
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 |
<Send To multiple sheets
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 |
All times are GMT +1. The time now is 10:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com