Hi.

There are 4 reports (Report names: OOA_Stars, OOA_Leaps, OOA_Bounds, OOA_Stripes) that posts to our internal SharePoint site every morning. Once they are updated, I manually send a standard email template informing distribution members after checking to make sure the reports have posted which can be quite tedious or I may simply forget to check the site.

I’m still a bit new to VBA and looking for a code that will send the email notification to a distribution list automatically once all 4 reports have been uploaded to the SharePoint site.

Can anyone assist me?

Thank you in advance.