E-mailing a worksheet only from a workbook

C

CAM

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Table of Contents 3
How to reference a cell from anther workbook without opening it 0
Macro shortcuts are running macros in different open workbook 3
e-mail excel files from a folder 2
VBA code for pasting links -- modifying RDB code for summary workbook 10
Changing name of worksheet based on data in cell of another worksheet 14
Customs views won't copy into new workbook 1
Deselect a worksheet? 3

Top