E-mailing a worksheet only from a workbook
 

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

E-mailing a worksheet only from a workbook
 

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

E-mailing a worksheet only from a workbook
 

There are a few ways to do this see
http://www.rondebruin.nl/sendmail.htm

--

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


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

E-mailing a worksheet only from a workbook
 

Thanks Ron. I appreciate your help.


"Ron de Bruin" wrote in message
...
There are a few ways to do this see
http://www.rondebruin.nl/sendmail.htm

--

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


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

E-mailing a worksheet only from a workbook
 

strive4peace - Thanks for the info.

Cheers

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

E-mailing a worksheet only from a workbook
 

you're welcome, Cam ;) happy to help

Warm Regards,
Crystal

remote programming and training

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

*
(: have an awesome day :)
*




CAM wrote:
strive4peace - Thanks for the info.

Cheers

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