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?

 

[Georgiboy]

In the top right corner of the screen when you have Outlook open, do you have a toggle button that states: 'Try the new Outlook'?

 

[drag1c]

In the top right corner of the screen when you have Outlook open, do you have a toggle button that states: 'Try the new Outlook'?

No. This is full preview of top part of the screen:

 

[Logit]

Georgiboy's point was going to be the new OUTLOOK doesn't allow for VBA sent emails.​

 

[Georgiboy]

Thanks @Logit, that was the point I was eluding to. I asked about the toggle because on my work computer I have 365 installed but on Outlook, I can switch between old and new with a toggle. I am not sure how long I will have the option though.

 

[Logit]

I have retained the old version on my computer.

 

[drag1c]

This is so sad. So, Microsoft decided to pull out COM object from Outlook.

Is there any other possible way to hook Outlook with VBA?

 

[Georgiboy]

Not that I know of, you may need to revert back to the old outlook. I have a toggle switch to do this but as I understand, not all installs have this. You may be able to achieve this within the registry but I am not familiar with this method and depending on your setup, it may not be suitable.

 

[saboh12617]

Hi all,

I'm very confuse because to me the ui does not look like the "New Outlook". Also why would you still have the COM reference if outlook is not present anymore?

When you go on windows search and type "outlook", do you have one or two results? Also the icons are different.

I have no idea why it does not work, but i think you have the correct version of Outlook.

 

[Trevor G]

Old Outlook is called Classic Outlook and you would need to use that version to run VBA through apps such as Excel.