View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
choice[_2_] choice[_2_] is offline
external usenet poster
 
Posts: 84
Default 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