Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default e-mail one worksheet as an attachment


--
Marilyn
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default e-mail one worksheet as an attachment

Easiest way I can think of is right click on the tab, select move or copy,
select new book from the drop down and check make a copy on the bottom, then
send the new workbook that has only 1 tab.

"Marilyn" wrote:


--
Marilyn

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default e-mail one worksheet as an attachment

Copy that ope sheet to a new workbook and email that workbook as attachment.

OR

See Ron de Bruin's site for code and/or an add-in which will do the same thing
without the manual steps.


http://www.rondebruin.nl/sendmail.htm


Gord Dibben MS Excel MVP



On Fri, 7 Mar 2008 09:50:03 -0800, Marilyn
wrote:


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
mail and attachment Jithu Excel Discussion (Misc queries) 1 July 9th 07 12:38 PM
E-Mail attachment to same e-mail address in Outlook Vick Excel Discussion (Misc queries) 4 May 17th 07 07:53 PM
how do i open e-mail attachment with spreadsheet isabell New Users to Excel 1 June 5th 05 08:10 PM
how to e-mail with an attachment using hotmail Excel not working with hotmail Excel Worksheet Functions 0 February 6th 05 06:35 PM
Cannot "Send to -> mail recipient (as attachment)" Jack Excel Discussion (Misc queries) 2 December 18th 04 12:04 PM


All times are GMT +1. The time now is 04:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"