NEW Outlook

I have some projetcs that use the COM method (Component Object Model - Microsoft Outlook Object Library, CreateObject("Outlook.Application"), etc.; see https://www.automateexcel.com/vba/send-emails-outlook/) to send a bunch of mails from the default account in Outloook (a Microsoft 365 account) to various recipients, typically attaching a tailored Excel-sheet, either as Excel-sheet or "printed" by VBA to a PDF. Works like a charm!

Alas, this does not work anymore if the user (in one case myself; in another a customer) has NEW Outlook installed. Apparently, NEW Outlook has abandoned the COM model. I have switched back to classic Outlook for now, but my customer may be forced to use NEW Outlook, and I suppose we all will at some point.

There is also a CDO method (Microsoft CDO for Windows 2000 Library, CreateObject("CDO.Message"), etc.; see https://codekabinett.com/rdumps.php?...access-vba-cdo). But it seems not to support STARTTSL; that seems to be a showstopper for me.

Is there any way I can rewrite my code to work with NEW Outlook - or perhaps more precisely, to work without classic Outlook? Is there another mail client or component one can install and link in somehow, or any other way a VBA/Excel project can send mail? Or can the STARTTSL issue be solved?

Please Login or Register  to view this content.

Apparently the earliest would be 2029
https://techcommunity.microsoft.com/...=M365-MVP-9501


COM Addins will not be supported.
https://support.microsoft.com/en-us/...b-ba7822bc7627


Voice your objection here
https://feedbackportal.microsoft.com...c-000d3ae46fcb