Email sheet in excel with vba

[Slade]

Hi

I want to email a sheet in excel. I use this code for a workbook and work but only want to send 1 sheet.

I did try ActiveSheet.Sendmail but does not seem there is such a function. Im using 2007

    ActiveWorkbook.SendMail _
    Recipients:="xxxxx@zzzzzz.com", _
    Subject:="Check Files " & Format(Date, "dd/mmm/yy")

 

[VoG]

You should find some suitable code here http://www.rondebruin.nl/sendmail.htm

 

[Slade]

Tnx will look there