I have an excel file that tracks leave time. For each employee there
is a seperate tab that tracks their hours What I need to do is
automatically email each employee just their sheet. I can do it
manually by File->Send to->email from each tab but that's boaring...
What I need is a "button" I can push to send out each tab
individually.

Can anyone point towards a solution? Should I look at mail merge?
Macros, or dive right into VBA?

Thanks.

Hi

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


You can use
http://www.rondebruin.nl/mail/folder1/mail5.htm

Or only for Outlook
http://www.rondebruin.nl/mail/folder2/mail5.htm
Or in the body
http://www.rondebruin.nl/mail/folder3/mail5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>I have an excel file that tracks leave time. For each employee there
> is a seperate tab that tracks their hours What I need to do is
> automatically email each employee just their sheet. I can do it
> manually by File->Send to->email from each tab but that's boaring...
> What I need is a "button" I can push to send out each tab
> individually.
>
> Can anyone point towards a solution? Should I look at mail merge?
> Macros, or dive right into VBA?
>
> Thanks.
>
>