e-mailing a single worksheet of a multiple worksheet (4) workbook

[ppete83606]

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

Thanks fo any help

Paul

[Gord Dibben]

For this type of operation I recommend Ron de Bruin's Sendmail Add-in(FREE)

http://www.rondebruin.nl/sendmail.htm

If you just want code for that particular operation just click on the
appropriate link on Ron's site at the above URL.


Gord Dibben Excel MVP

On Sat, 3 Sep 2005 13:26:08 -0500, ppete83606
<[email protected]> wrote:

>
>I have a requirement to e-mail one worksheet of a multiple worksheet
>workbook to another department. The workbook contains 4 seperate
>worksheets, and I don't want to e-mail the whole workbook to a
>department that doesn't need it. I can do it manually, is there a way
>to select the wooksheet I want to e-mail with vba and do it
>automatically ?
>
>Thanks fo any help
>
>Paul

[Earl Kiosterud]

ppete,

Look in excel.misc recently. Search for "save one sheet."

Earl Kiosterud
www.smokeylake.com

"ppete83606" <[email protected]> wrote
in message news:[email protected]...
>
> I have a requirement to e-mail one worksheet of a multiple worksheet
> workbook to another department. The workbook contains 4 seperate
> worksheets, and I don't want to e-mail the whole workbook to a
> department that doesn't need it. I can do it manually, is there a way
> to select the wooksheet I want to e-mail with vba and do it
> automatically ?
>
> Thanks fo any help
>
> Paul
>
>
> --
> ppete83606
> ------------------------------------------------------------------------
> ppete83606's Profile:
> http://www.excelforum.com/member.php...o&userid=26953
> View this thread: http://www.excelforum.com/showthread...hreadid=401714
>