View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Madhan Madhan is offline
external usenet poster
 
Posts: 78
Default send excel by email

Hi,
A sheet is not a standalone object (otherwise, Microsoft would have
provided objects at operating system level to recognise them). It exists
within the workbook object, hence, you may not be able to send only worksheet
in an e-mail.

"Sérgio Aires" wrote:

hi
I'm trying to send a sheet by email, but I want to send just a sheet. I'm
using this code:
ActiveWorkbook.SendMail "

but with this code all file is send.
how can I do for to send just a sheet??

thanks

--
Sérgio Aires
Lisboa
Portugal