View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cam Cam is offline
external usenet poster
 
Posts: 165
Default Automatic email to recipient

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