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

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

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

"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.

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