Check out Ron's site. Everything you ever wanted to know...

http://www.rondebruin.nl/

HTH

"choice" wrote:

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