Automating Excel Reports from Outlook

  • Hi! I was wondering if it possible to automate some daily reporting. I currently receive about 6 different scheduled emails (all excel attachments) from a scheduler containing data dumps. I run each one through macros that aggregates and formats the data. From there i simply email them to the corresponding recipients ( distribution lists actually). Is it possible to automate this process of opening each spreadsheet, running the macro, and then emailing it again to a distribution list?