Email selected tabs of spreadsheet?
 

I created a 15-tab spreadsheet. Most of the tabs interact in some fashion.

I want to email certain tabs without the others attached. Is this possible?

Email selected tabs of spreadsheet?
 

Hi "DrWilki", posted in excel.misc
Create a macro to copy the entire workbook,
delete the worksheets you don't want, then save the new
workbook, and to send it to email recipient.

Take a look at Ron's addin
http://www.rondebruin.nl/mail/add-in.htm
not clear to me if selection means selection of cells,
or selection of worksheets, but I think it would be
worksheets as it is workbooks that are being emailed..

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"DrWilki" wrote in message
...
I created a 15-tab spreadsheet. Most of the tabs interact in some fashion.

I want to email certain tabs without the others attached. Is this
possible?

Email selected tabs of spreadsheet?
 

If the OP want to use code he can also use this macro
http://www.rondebruin.nl/mail/folder1/mail3.htm


See the note below the macro
*************************
You can also use the this line if you want to send the selected sheets.
ActiveWindow.SelectedSheets.Copy





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"David McRitchie" wrote in message ...
Hi "DrWilki", posted in excel.misc
Create a macro to copy the entire workbook,
delete the worksheets you don't want, then save the new
workbook, and to send it to email recipient.

Take a look at Ron's addin
http://www.rondebruin.nl/mail/add-in.htm
not clear to me if selection means selection of cells,
or selection of worksheets, but I think it would be
worksheets as it is workbooks that are being emailed..

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"DrWilki" wrote in message
...
I created a 15-tab spreadsheet. Most of the tabs interact in some fashion.

I want to email certain tabs without the others attached. Is this
possible?

Email selected tabs of spreadsheet?
 

Thanks for the replies. I was hoping for another route, but did feel this
was probably the only option.

Dale

"Ron de Bruin" wrote:

If the OP want to use code he can also use this macro
http://www.rondebruin.nl/mail/folder1/mail3.htm


See the note below the macro
*************************
You can also use the this line if you want to send the selected sheets.
ActiveWindow.SelectedSheets.Copy





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"David McRitchie" wrote in message ...
Hi "DrWilki", posted in excel.misc
Create a macro to copy the entire workbook,
delete the worksheets you don't want, then save the new
workbook, and to send it to email recipient.

Take a look at Ron's addin
http://www.rondebruin.nl/mail/add-in.htm
not clear to me if selection means selection of cells,
or selection of worksheets, but I think it would be
worksheets as it is workbooks that are being emailed..

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"DrWilki" wrote in message
...
I created a 15-tab spreadsheet. Most of the tabs interact in some fashion.

I want to email certain tabs without the others attached. Is this
possible?

Email selected tabs of spreadsheet?
 

I was hoping for another route

Manual you can select the tabs and right click on it and choose "Move or Copy"

You can copy the sheets in a new workbook this way and send that workbook
This is very easy with the add-in

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DrWilki" wrote in message ...
Thanks for the replies. I was hoping for another route, but did feel this
was probably the only option.

Dale

"Ron de Bruin" wrote:

If the OP want to use code he can also use this macro
http://www.rondebruin.nl/mail/folder1/mail3.htm


See the note below the macro
*************************
You can also use the this line if you want to send the selected sheets.
ActiveWindow.SelectedSheets.Copy





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"David McRitchie" wrote in message ...
Hi "DrWilki", posted in excel.misc
Create a macro to copy the entire workbook,
delete the worksheets you don't want, then save the new
workbook, and to send it to email recipient.

Take a look at Ron's addin
http://www.rondebruin.nl/mail/add-in.htm
not clear to me if selection means selection of cells,
or selection of worksheets, but I think it would be
worksheets as it is workbooks that are being emailed..

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"DrWilki" wrote in message
...
I created a 15-tab spreadsheet. Most of the tabs interact in some fashion.

I want to email certain tabs without the others attached. Is this
possible?