Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to email only one tab from a workbook with multiple tabs...can you help?
-- Thanks, Kathy |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
right click on the tab name - click on Move or Copy - select the tab as your
needs - check the box Create a copy and on the drop down button select new book, save the new book and email. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Kathy" escreveu: I need to email only one tab from a workbook with multiple tabs...can you help? -- Thanks, Kathy |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Have a look here
Mike "Kathy" wrote: I need to email only one tab from a workbook with multiple tabs...can you help? -- Thanks, Kathy |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It would help if I included the link
http://www.rondebruin.nl/sendmail.htm Mike "Kathy" wrote: I need to email only one tab from a workbook with multiple tabs...can you help? -- Thanks, Kathy |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Kathy,
I am rearranging the steps shown by Marcelo. 1. Right click on the worksheet tab you intend to email. 2. Select "move or copy" 3. In the window, from the drop down list select "New Book". 4. Then Check the "Create a Copy" check box. By doing this the exist sheet will not be separated but a new workbook with the specified sheet will be generated as book 1 and the original workbook would be intact. You can then email the entire work book as an attachment. -- Thanks Suleman Peerzade "Marcelo" wrote: right click on the tab name - click on Move or Copy - select the tab as your needs - check the box Create a copy and on the drop down button select new book, save the new book and email. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Kathy" escreveu: I need to email only one tab from a workbook with multiple tabs...can you help? -- Thanks, Kathy |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
As you had started a new thread, I did not see you had already received this
suggestion from earlier postings. -- Regards Roger Govier "Mike H" wrote in message ... It would help if I included the link http://www.rondebruin.nl/sendmail.htm Mike "Kathy" wrote: I need to email only one tab from a workbook with multiple tabs...can you help? -- Thanks, Kathy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbook Tabs? | Excel Discussion (Misc queries) | |||
Workbook tabs | Excel Discussion (Misc queries) | |||
Sumif across workbook tabs | Excel Worksheet Functions | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Workbook Tabs | Excel Discussion (Misc queries) |