A worksheet cannot exist outside of a workbook, so you'll need to
copy the one sheet to a new workbook, and email that workbook.
E.g,.


Worksheet("Sheet1").Copy
ActiveWorkbook.SendMail "



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"choice" wrote in message
...
i have:

Sub Mailtmobile()
Workbooks("tmobilemonthend.xls").activate
Sheets("Monthly Log").activate

Activesheets.SendMail ", _
Range("bringin!z3").Value
End Sub

basically i want to email just one sheet of the workbook.

thanks in advance