ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   e-mail one worksheet as an attachment (https://www.excelbanter.com/excel-discussion-misc-queries/179156-e-mail-one-worksheet-attachment.html)

Marilyn

e-mail one worksheet as an attachment
 

--
Marilyn

Sean Timmons

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


Gord Dibben

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:




All times are GMT +1. The time now is 05:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com