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

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

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

in workbook tmobilemonthend, theres two sheets "Monthly Log" & "Bringin"
so if i copy "Monthly Log" to a new workbook save it as "March Log" then
email "March Log" that would work right

"Chip Pearson" wrote:

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