| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro problem: Won't send messages | Excel Programming | |||
| sending email without outlook messages | Excel Programming | |||
| Sending email from Excel vba problem | Excel Programming | |||
| Sending Text Messages with Excel??? | Excel Worksheet Functions | |||
| Sending messages | Excel Programming | |||
Hybrid Mode
