email a worksheet

[rekoop]

Help...how can I email one(or multiple) worksheets but
note the entire workbook?

Thanks

 

[Frank Kabel]

Hi
try Ron's sendmail add-in:
http://www.rondebruin.nl/sendmail.htm

 

[Rekoop]

Thank for this information.
But... is there a method native to default excel
settings? The instructions in Excel Help do not appear
to work as they indicate. Help Search Term "Send a
worksheet in e-mail".
In the intructions I do not receive the prompt "Send the
current sheet as the message body". I only end up
attaching the entire workbook?!

Thanks again

 

[Ron de Bruin]

Not possible in 97/2000Excel 2002 HOW TO: Use the "Send To" Menu Command to Send Worksheets and Workbooks as E-Mail in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;289272 Excel 2003 HOW TO: Use the Send To Command to Send Worksheet
Selections as E-Mail in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;826920

 

[Ron de Bruin]

This is better

Not possible in 97/2000

Excel 2002 HOW TO: Use the "Send To" Menu Command to Send Worksheets and Workbooks as E-Mail in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;289272

Excel 2003 HOW TO: Use the Send To Command to Send Worksheet Selections as E-Mail in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;826920