I have a requirement to e-mail one worksheet of a multiple workshee
workbook to another department. The workbook contains 4 seperat
worksheets, and I don't want to e-mail the whole workbook to
department that doesn't need it. I can do it manually, is there a wa
to select the wooksheet I want to e-mail with vba and do i
automatically ?

Thanks fo any help

Pau

--
ppete8360
-----------------------------------------------------------------------
ppete83606's Profile: http://www.excelforum.com/member.php...fo&userid=2695
View this thread: http://www.excelforum.com/showthread.php?threadid=40171