Hello everyone! I want to know if there is a way to send emails in Outlook when an Excel cell is updated.
To be specific: I use a checkbox and I need an email to be sent when it changes from FALSE to TRUE. My Excel file has more than 7,000 rows and may continue to grow.
1. Create a flow that gets called via HTTP, and then create some VBA script code that when you CheckThebox it will trigger the flow from VBA
2. You could use when an item is added or modified, and then add a condition check if your Checkbox cell is equal to true (meaning checked).
You will need a premium license for the first option and some additional authentication configuration.
At this point I am certain ChatGPT or CoPilot or any other AI can write the code for you on the VBA side its been done 109000000000 times before lol
If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.
Thank you!
Sincerely, Michael Gernaey
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.