Problem with sending messages
 

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

Problem with sending messages
 

Do you have Outlook on your machine ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Adam" wrote in message ...
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

Problem with sending messages
 

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" wrote:

Do you have Outlook on your machine ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Adam" wrote in message ...
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

Problem with sending messages
 

Try this first in Excel

Run Office Diagnostics.
Office ButtonExcel Options...Resources



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Adam" wrote in message ...
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" wrote:

Do you have Outlook on your machine ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Adam" wrote in message ...
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

Problem with sending messages
 

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

Adam

"Ron de Bruin" wrote:

Try this first in Excel

Run Office Diagnostics.
Office ButtonExcel Options...Resources



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Adam" wrote in message ...
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" wrote:

Do you have Outlook on your machine ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Adam" wrote in message ...
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