Forum Discussion
Solved
Send out an email automatically at a specific time and date using VBA
I would like to have an email to be triggered automatically on every Monday at a specific timing without executing the macro manually. How can i amend the code below? Private Sub sende...
- You might use WIndows task scheduler for this. But you'll have to make sure the macro is called from Workbook_Open in the ThisWorkbook module and you'll have to run the task using your account credentials. Alternatively, if you're on Microsoft 365, you can use Power Automate to create a flow that does the same and runs on a schedule.
You might use WIndows task scheduler for this. But you'll have to make sure the macro is called from Workbook_Open in the ThisWorkbook module and you'll have to run the task using your account credentials. Alternatively, if you're on Microsoft 365, you can use Power Automate to create a flow that does the same and runs on a schedule.
JKPieterse , thanks and appreciate the help!
