Excel VBA generate email to M365 Outlook

[drag1c]

Hi,

I've tried test code below those images, to generate email via M365 Outlook.
So, both Excel and Outlook are in the same package M365 64-bit and this is their interface:

So, this looks pretty new to me and it's not Web based. This is application installed on my company PC. In past we were using Office 2016 32-bit package.

I have this library activated:

And this is my test code:

Sub TestOutlook()
    Dim objOutlook As Object
    Dim objMail As Object


    Set objOutlook = CreateObject("Outlook.Application")
    Set objMail = objOutlook.CreateItem(0)

    With objMail
        .To = "your_email@example.com"
        .Subject = "Test Email"
        .body = "This is a test email."
        .display
    End With

    Set objMail = Nothing
    Set objOutlook = Nothing
End Sub

It gives error:

Automation error. The specified module could not be found.

Crash happens in this row:

Set objOutlook = CreateObject("Outlook.Application")

Does anyone have idea what is problem here?

 

[Logit]

Download Classic Version of Outlook :

Outlook for Windows (classic) - Download and install on Windows | Microsoft Store

Outlook for Windows (classic) is the desktop app for your email, calendars, contacts, and to-dos in one place. Sign in with your work, school, or personal Microsoft account to get started. A Microsoft 365 Personal or Family subscription is required to use this app with personal accounts. With...

apps.microsoft.com

 

[drag1c]

This is pretty strange. It is classic version but I can't hook COM Object.

Anyway, we can close this topic. If classic is going to disappear, I need permanent solution, not temporary.
I've achieved something via shell, but it doesn't allow me to use html tags. Just plain text...

Thank you all.