How to email only one sheet in Excel?

[Maisie2007]

Hi,

I have a workbook with several pages in it, but I only want to email 1 sheet - is this possible?

Thanks,
Maisie

 

[longhair]

Maisie2007,
you should be able to save the sprcified sheet to another workbook name and email that. if you record a macro, of you doing it manually it will give you the base vba code that you need.
regards,
longhair

 

[SkipVought]

Maisie2007,

Please be precise with your questions.

Excel does not have "pages." You have a workbook with several sheets in it.

However, when you print one or more sheets, you will generate page(s) of print.



Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[PeterMoran]

Hi,

Checkout Allan Wyatt's Excel Tips at:

http://exceltips.vitalnews.com/Pages/T1353_Sending_Single_Worksheets_via_E-mail.html

for the answer.

Then subscribe to his weekly tips for a fountain of Excel knowledge - really!!

Good Luck!

Peter Moran

 

[xlbo]

See this FAQ from the VBA forum on saving a sheet seperately. You can use the same method and send rather than save: faq707-2482

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question