I am using Office 365, and am storing Excel files in the shared OneDrive. I would like Excel to send automated emails, either based on a dynamic schedule (e.g. storing a list of dates in one of the sheets), or being triggered by some data in one of the sheets that gets updated dynamically based on Microsoft Forms form submissions.
How can I do that? I have been given to understand that VBA doesn't work with online Excel, and that something like Office script should be used ...
How can I do that? I have been given to understand that VBA doesn't work with online Excel, and that something like Office script should be used ...