e-mail a worksheet from a spreadsheet
 

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

e-mail a worksheet from a spreadsheet
 

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




"Dale" wrote in message ...
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

e-mail a worksheet from a spreadsheet
 

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
---------------
Jacob Skaria


"Dale" wrote:

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