Forum Discussion
JaimeSanchezRamos
Aug 21, 2024Copper Contributor
Looking for a macro for automatic sorting by due date and emailing oneself when item is due
Hi everyone, I am trying to see if someone could help me with making a macro that will automatically sort by closest due dates. In my table there are 2 columns one titled assessment date and due...
JKPieterse
Aug 22, 2024Silver Contributor
JaimeSanchezRamos In order for a VBA macro to work, your file needs to be opened in Excel. This means you will have to be logged on to your machine and open the file. Since you're opening the file anyway, you can then filter the column for the # of days remaining before the due date and see which are up for action. At that point, sounds to me like sending yourself an email isn't really helpful.
If you are using Microsoft 365 and your file is stored on either Sharepoint or OneDrive, you can write a small Office Script that filters your table for the remaining days. You can then create a power Automate flow and set it to run once a day to email the filtered table to you. That sounds more helpful to me 🙂