e-mail a worksheet from a spreadsheet

[Dale]

I am trying to e-mail a single worksheet from a spreadsheet that has several
worksheets. I have one sheet that is a data source for my call logs and 5
different worksheets to send to my employees with different action items. I
kow a database would be better but it is not feasible at the time. I am using
Excel 2003 but can upgrade to 2007 if need to accomodate this functionality.

Thanks

Dale

 

[Ron de Bruin]

Hi Dale

I have code examples here

Maybe example 2 here is what you want to send each sheet to the person you want
http://www.rondebruin.nl/mail/folder1/mail2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

I am trying to e-mail a single worksheet from a spreadsheet that has several
worksheets. I have one sheet that is a data source for my call logs and 5
different worksheets to send to my employees with different action items. I
kow a database would be better but it is not feasible at the time. I am using
Excel 2003 but can upgrade to 2007 if need to accomodate this functionality.

Thanks

Dale

__________ Information from ESET Smart Security, version of virus signature database 3957 (20090324) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 3957 (20090324) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Jacob Skaria]

Right click on the sheet tab to be emailed.
Within 'Move or Copy' check create a copy and specify new workbook.
This will copy the sheet to a different workbook
From File. Send To Email ...

If this post helps click Yes