Excel VBA Office 2019 Class not Registered Run time Error 2147721164 (80040154)

Question

Hi

I have a macro that used to run fine and now gives me the error message as shown below

I need to open up outlook and then loop through a database to send a customized emails to each person

I created a brand new spreadsheet so there is nothing in it except the macro

it blows up and gives me the error message on the line

Set Testmail_object = CreateObject("Outlook.Application")

I have googled this and no one seems to address the problem

Thank you!

Answer 1

Hi, I'm Elise, an Independent Advisor and I'd be happy to help with your issue.

In the VBA editor can you go to Tool > References and then check that the Outlook Object Library has been checked?

Kind Regards,

Elise

Answer 2

Thanks for the suggestion.

It was not checked, but after I checked it, it still did not run

Could it be an outlook problem?

R

Answer 3

The other common reason for this is if you have two version of office installed. Eg. 2013 and 2016 editions?

Do you know if this is the case on your device?

Kind Regards,

Elise

Answer 4

Thanks for the response

I still have office 2007 installed (but for long time it worked fine with that)

I used to have some Office 2016 but think it is all gone.

On the start menu I do have

Office 2016 Tools

• database compare
• office upload center
• spreadsheet compare

see below for list of installed Microsoft programs

Thanks for the assistance

Answer 5

Thank you all for the assistance.

I upgraded to Outlook 2019, and it now seems to work.

Not sure why the error appeared in the first place or why it went away, but now works

Regardless

a) shame on microsoft for making such cryptic errors

b) THANK YOU to everyone that tried to help