| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Sending sheets in workbook
Hi, could somebody tell me if there is a way to send different sheets of a workbook to different departments with different emails. I have my information compiled in one workbook (the way I like it) and want to send my worksheets as an attachment to the different department directors. -- billy2willy ------------------------------------------------------------------------ billy2willy's Profile: http://www.excelforum.com/member.php...o&userid=21648 View this thread: http://www.excelforum.com/showthread...hreadid=390782 |
|
#2
|
|||
|
|||
|
For the sheet you wish to send, select Edit, Move or Copy Sheet, tick Create a Copy, select book 'New Book' and email the new book -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390782 |
|
#3
|
|||
|
|||
|
That is to time consuming if you have to do that for 14 different sheets once a month, there must be an easier way. -- billy2willy ------------------------------------------------------------------------ billy2willy's Profile: http://www.excelforum.com/member.php...o&userid=21648 View this thread: http://www.excelforum.com/showthread...hreadid=390782 |
|
#4
|
|||
|
|||
|
"billy2willy"
wrote in message ... That is to time consuming if you have to do that for 14 different sheets once a month, there must be an easier way. You are probably not aware that you are actually posting to a Public Usenet Newsgroup. Please follow Usenet convention and quote the post you are replying to. Thank you. |
|
#5
|
|||
|
|||
|
See my site for code examples
http://www.rondebruin.nl/sendmail.htm Maybe you can use the templates ? -- Regards Ron de Bruin http://www.rondebruin.nl "billy2willy" wrote in message ... That is to time consuming if you have to do that for 14 different sheets once a month, there must be an easier way. -- billy2willy ------------------------------------------------------------------------ billy2willy's Profile: http://www.excelforum.com/member.php...o&userid=21648 View this thread: http://www.excelforum.com/showthread...hreadid=390782 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbering sheets in workbook | Excel Worksheet Functions | |||
| Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
| Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
