| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mailing each worksheet in Workbook | Excel Discussion (Misc queries) | |||
| e-mail individual worksheet/tab w/out e-mailing entire workbook? | Excel Discussion (Misc queries) | |||
| E-mailing a worksheet from a workbook using Windows Mail | New Users to Excel | |||
| e-mailing a single worksheet of a multiple worksheet (4) workbook | Excel Programming | |||
| mailing one sheet from workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
