Macro to email multiple worksheets
 

I currently have a spreadsheet that has multiple worksheets, each used to
report information to different managers on a fortnightly basis. Currently I
manually email the worksheets, each sheet being email to a different manager.
As I email the same sheets to the same managers each fortnight I was
wondering if it is possible to use a macro to do this for me.

I am using Excel and Office 2003.

Try this Daniel
http://www.rondebruin.nl/mail/folder2/mail5.htm

Or a template
http://www.rondebruin.nl/mail/templates.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Daniel" wrote in message ...
I currently have a spreadsheet that has multiple worksheets, each used to
report information to different managers on a fortnightly basis. Currently I
manually email the worksheets, each sheet being email to a different manager.
As I email the same sheets to the same managers each fortnight I was
wondering if it is possible to use a macro to do this for me.

I am using Excel and Office 2003.