Macro to Email a Worksheet not a Workbook

[Guest_imported]

I am trying to setup a Macro in Excel to automatically send the active worksheet via Email. I know how to send the entire workbook this way, but I was wondering if there is a way to specify just a particular worksheet.

Becky

 

[SkipVought]

Hi,

Why not in your macro...

1. copy sheet to New workbook

2. eMail

Skip,
metzgsk@voughtaircraft.com

 

[acron]

The following code should help :

ActiveSheet.Copy
ActiveWorkbook.SendMail Recipients:="somebody@emailaddress"

Cheers