I need to create an auto-generated email when date in the one of columns in the list matched today's date.
closed as unclear what you're asking by Gaurravs, MHeld, Aakash Maurya, Karthik Jaganathan, Asad Refai Mar 5 at 9:06
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
If you are on SharePoint online it is now a OOTB Flow. Another option could be a timer job in Azure that checks the dates in the list against today.
If you are using on premises a scheduled timer job (C# or PowerShell) could be an option
In both cases you can use either CAML or Search to locate the items where the date field matches today (be careful about the timezone issue)