@MS Prog Thank you for reaching out.
As you have rightly identified, OLE Automation is not available on Azure SQL Managed Instance.
For you use case, you can use Azure Data Factory with a HTTP Connector to call an external service/website via HTTP
Refer to the documentation here for step-by-step instructions
To send emails from an ADF pipeline, refer to the instructions here
----------
If an answer is helpful, please click on or upvote which might help other community members reading this thread.