Hi Cam,

yes, look he

tips from MrExcel.com
http://www.mrexcel.com/tip016.shtml


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




CAM wrote:
Hello,

I have a workbook call "Master" that has 15 different worksheets. What
I want to do is to e-mail each worksheet to their respective managers.
I would make 15 different workbooks and then e-mail to the different
managers. There has to be a way I can use the "Master" file and e-mail
the worksheets individually. Has anybody run into this problem before?
Any tips will be appreciated. Thank you in advance.

Cheers