Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
e-mail individual worksheet/tab w/out e-mailing entire workbook?
As an attachment, how do I e-mail an individual worksheet/tab within a
workbook with e-mailing the entire workbook? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
e-mail individual worksheet/tab w/out e-mailing entire workbook?
A worksheet cannot exist outside of a workbook. Therefore, you need to
copy the worksheet to a new workbook and email that workbook. For example, ThisWorkbook.Worksheets("sheet1").Copy ' Newly created workbook is now ActiveWorkbook ActiveWorkbook.SendMail ", "One Worksheet" ActiveWorkbook.Close savechanges:=False The first line of code copies Sheet1, creating a new workbook containing only Sheet1. After the copy is complete, that newly created workbook is then the active workbook. The code sends that workbook via email and then closes it without saving. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 13 Mar 2009 13:23:02 -0700, Cookie Monster <Cookie wrote: As an attachment, how do I e-mail an individual worksheet/tab within a workbook with e-mailing the entire workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E-mailing a worksheet from a workbook using Windows Mail | New Users to Excel | |||
How do I email one Excel worksheet and not the entire workbook | Excel Discussion (Misc queries) | |||
How do I email a single worksheet, not the entire workbook? | Excel Discussion (Misc queries) | |||
Can I e-mail only one worksheet in a workbook using MSN Hotmail? | Excel Discussion (Misc queries) | |||
is there a way to export just 1 worksheet of an entire workbook | Excel Worksheet Functions |