Sending sheets in workbook

[billy2willy]

Hi, could somebody tell me if there is a way to send different sheets o
a workbook to different departments with different emails. I have m
information compiled in one workbook (the way I like it) and want t
send my worksheets as an attachment to the different departmen
directors

 

[Bryan Hessey]

For the sheet you wish to send, select Edit, Move or Copy Sheet, tic
Create a Copy, select book 'New Book' and email the new boo

 

[billy2willy]

That is to time consuming if you have to do that for 14 different sheets
once a month, there must be an easier way.

 

[Gordon]

"billy2willy" <[email protected]>
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.

 

[Ron de Bruin]

See my site for code examples
http://www.rondebruin.nl/sendmail.htm

Maybe you can use the templates ?