How to Email single worksheet?

[Bill James]

Would like to email a single worksheet as attachment or body of message.
Not to whole workbook. I've played with the Send To options but can't seem
to record the VBA code.

[Norman Jones]

Hi Bill,

See Ron de Bruin's SendMail pages for sample code:

http://www.rondebruin.nl/sendmail.htm


---
Regards,
Norman



"Bill James" <singamoona@softhome.net> wrote in message
news:Oxx$CWE2FHA.3892@TK2MSFTNGP12.phx.gbl...
> Would like to email a single worksheet as attachment or body of message.
> Not to whole workbook. I've played with the Send To options but can't
> seem to record the VBA code.
>

[David Adamson]

Bill,

Check out Ron de Bruin's page on this topic at

http://www.rondebruin.nl/sendmail.htm




"Bill James" <singamoona@softhome.net> wrote in message
news:Oxx$CWE2FHA.3892@TK2MSFTNGP12.phx.gbl...
> Would like to email a single worksheet as attachment or body of message.
> Not to whole workbook. I've played with the Send To options but can't
> seem to record the VBA code.
>

[Bill James]

Thanks you both... good link.

"Bill James" <singamoona@softhome.net> wrote in message
news:Oxx$CWE2FHA.3892@TK2MSFTNGP12.phx.gbl...
> Would like to email a single worksheet as attachment or body of message.
> Not to whole workbook. I've played with the Send To options but can't
> seem to record the VBA code.
>