I'm not sure how you are refreshing all sheets now (I can think of a few ways
of doing it.). Anyway, this will give you the email functionality you asked
for:
http://www.rondebruin.nl/sendmail.htm

Regards,
Ryan---

--
RyGuy


"Cam" wrote:

Hello,

I have an Excel file with different worksheet for different area/department
that I refreshed everyday, then send the file as an attachment in Outlook to
different people in the distribution list.

I would like to automate this process to refresh all sheets, then auto email
out to recipients in the distribution list twice a week. Thanks for any help