email one sheet of workbook
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
|