Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set outlook task through excel
Hi,
I have adapted some code I found in JP site on setting outlook tasks through excel. I now make it happen on a change event however I have the following doubt. Am I right in thinking the following code checks if outlook is open and otherwise opens it. Because I get an error message when I run the code and outlook is closed. On Error Resume Next Set olApp = GetObject(, "Outlook.Application") If Err.Number < 0 Then Set olApp = CreateObject("Outlook.Application") End If On Error GoTo 0 On the other hand if I add the following line after "End If" olApp.Session.Logon then I don't get the error message and although I don't see outlook opening I do find the task when I open it manually. Can someone please explain the above? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How create an Outlook task from Excel | Excel Programming | |||
Creating task in outlook from a particular row in excel | Excel Programming | |||
Excel to Schedule Task in Outlook | Excel Programming | |||
Creating Outlook Task from Excel | Excel Programming | |||
Searching for an Outlook Task from Excel | Excel Programming |