Hi.
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.
Nicole
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.
Nicole