VBA Script to Send Automatic Emails from Outlook 2010


New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server 2010

There are reports updated to our SharePoint site every morning. This update can take place at different times each day.

I have a standard email template saved that I manually send out to a distribution list but usually have to check the SharePoint first which became quite tedious so I created a notification that emails me an alert when the upload is complete. Unfortunately, my day gets busy causing me to forget to check for this alert.

I’m very green when with VBA and looking for a code that will allow Outlook to automatically send the email template to a distribution list once I receive the alert from SharePoint when reports have been uploaded.

Can anyone assist me with this?

Thank you in advance.


Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange