Problem with sending messages

[Adam]

Hi,

I am using the following statement to activate outlook to be able to send a
few messages:

Dim outapp As Object
Set outapp = CreateObject("Outlook.Application")
outapp.Session.Logon

In the second line I get an error message "Activex cannot creat object".
How can I solve it? I use Office2007.

Regards,

Adam

 

[Ron de Bruin]

Do you have Outlook on your machine ?

 

[Adam]

Yes, I do. The code worked perfectly with 97/2003 version but
now I have got the problem I described below
(it does not work neither with outlook open nor with outlook closed)

Adam

 

[Ron de Bruin]

Try this first in Excel

Run Office Diagnostics.
Office Button>Excel Options...Resources

 

[Adam]

Wow, it works! I ran it and it fixed an installation problem.
The code works now, as it used to.
A big thanks!

Adam