ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I insert just one worksheet of a workbook into an email? (https://www.excelbanter.com/excel-discussion-misc-queries/61095-how-do-i-insert-just-one-worksheet-workbook-into-email.html)

Sarah

How do I insert just one worksheet of a workbook into an email?
 
I have a workbook that holds all pertinent niformation for a particular
account. Some of the sheets have budgetary information that should not be
shared. But one of the sheets is one that I need to email regularly to
another agency. I haven't been ablet o figure out how to insert just the
sheet I need into an email. I have Microsoft Windows XP Home edition version
2002. Any help would be appreciated.

Gord Dibben

How do I insert just one worksheet of a workbook into an email?
 

Sarah

You can copy the worksheet into a new workbook and send that workbook as an
attachment.

OR..................

Download Ron de Bruin's SendMail add-in which allows sending one sheet only in
an email.

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


Gord Dibben Excel MVP


On Mon, 19 Dec 2005 11:57:03 -0800, "Sarah"
wrote:

I have a workbook that holds all pertinent niformation for a particular
account. Some of the sheets have budgetary information that should not be
shared. But one of the sheets is one that I need to email regularly to
another agency. I haven't been ablet o figure out how to insert just the
sheet I need into an email. I have Microsoft Windows XP Home edition version
2002. Any help would be appreciated.


Paul B

How do I insert just one worksheet of a workbook into an email?
 
Sarah, have a look at Ron's site here for a way to do it

http://www.rondebruin.nl/mail/folder1/mail2.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sarah" wrote in message
...
I have a workbook that holds all pertinent niformation for a particular
account. Some of the sheets have budgetary information that should not be
shared. But one of the sheets is one that I need to email regularly to
another agency. I haven't been ablet o figure out how to insert just the
sheet I need into an email. I have Microsoft Windows XP Home edition
version
2002. Any help would be appreciated.





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

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