Good Morning,

I have a rather complicated task that I've been trying find a solution to. I have a website that tracks user tasks (reading task completion) for documents for our organization. The information is pulled into an excel database through a query that we run on the site. These are the steps I have to take:

-Log onto the main site.
-open new window and log onto the custom query site
-select the saved query (selected from drop down list)
-click the "save to excel" option
-click "open" when prompted from excel

I have all the macros set up once the content is within excel. I'm still iffy on the automatically sending an email of the finished report, but I at least know that is possible. Any thoughts on the beginning of the process? I'd like this task to run automatically every morning to send to our privacy officer.

Thanks!