Macro won't create email

[DougRobertson]

Hello,

What a frustrating day! My hard drive died, I had to re-format / re-setup all my files and macros, and now a macro that has created email for years doesn't want to play ball.

With the code: Set otlapp = CreateObject("Outlook.Application")

It sends the error message: "ActiveX component can't create object."

Any ideas?

I'm running Excel 2010.

~ Doug
<!-- / message -->

 

[tweedle]

Do other email apps create the object?
Might check the registry for existance of Class "Outlook.Application" which should have a reference to another key of your current install version of Outlook.
If not, the Outlook installl needs to be addressed.

 

[DougRobertson]

Thanks T.

In realizing I was in over my head, I decided to find where the geniuses behind Office 2010 moved the Detect and Repair button to this time . . . . then ran it, and voila - the universe is back to running in sweet harmony!

Appreciate your help on this,

~ Doug

 

[Ruddles]

the universe is back to running in sweet harmony!

So it was you who caused the rainy Bank Holiday weather in the UK yesterday!

 

[DougRobertson]

HA!

Sorry 'bout that chief, but I'm from Rain-couver, BC, Canada. You want to talk weather? There's a reason our forests are always lush and green!

It could be worse though; there's a city on our prairies named Winnipeg, and they say that they have 10 months of winter, and 2 months of bad ice each year!

I hope the sun comes out in time for Wimbledon.

Rule Britannia!


~ Doug