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

Glad you have it working now,

Kind Regards,

Elise