Outlook Calendar Items

[VishnuNair]

Hello,

I am new to AutoIt and am working on script which can check the outlook calendar for a given time slot and give an output if that slot is free or not. If not list the appointments.

can this be done using the OutlookEX UDF? Please note i am using Outlook 2013

Please let me know.

Thanks,

Vishnu

 

Edited August 25, 2015 by VishnuNair

[water]

Please have a look at function _OL_RecipientFreeBusyGet from the OutlookEX UDF.

[VishnuNair]

Thanks Water. I will take a look at the OL_RecipientFreeBusyGet Function. Is this function intended only for the recipient or also for the sender? Meanwhile I have written a script using the OL_AppointmentGet function. I am not sure what is wrong here. The $appt never gives any value. Can you please help?

 

While 1
    $nMsg = GUIGetMsg()
    Switch $nMsg
        Case $GUI_EVENT_CLOSE
            Exit

        Case $Button1
            $StartDate = GUICtrlRead($Inputdt1)
            $StartTime = GUICtrlRead($Inputtm1)
            $EndDate = GUICtrlRead($Inputdt2)
            $EndTime = GUICtrlRead($Inputtm2)

            $Appt = _OL_AppointmentGet($OOutlook, $Path, $StartDate, $StartTime)
            If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_FolderAccess Example Script", "Error accessing the default contacts folder. @error = " & @error)

            MsgBox(0x40000000, 0,'get appointment ' &$Appt)
        _OL_Close($oOutlook)
    EndSwitch
WEnd

Edited August 25, 2015 by VishnuNair

[water]

The function returns a one based two-dimensional array. That's why MsgBox doesn't work. Use _ArrayDisplay instead.

[water]

_OL_RecipientFreeBusyGet function. Is this function intended only for the recipient or also for the sender?

Call the function for all people who should attend the meeting. Then check the results for a free time.

[VishnuNair]

Thank you Water. I used the _OL_RecipientFreeBusyGet function in the following code and attached is the result.

 

 

While 1
    Global $nMsg = GUIGetMsg()
    Switch $nMsg
        Case $GUI_EVENT_CLOSE
            Exit

        Case $Button1
            Global $StartDate = GUICtrlRead($Inputdt1)
            Global $StartTime = GUICtrlRead($Inputtm1)
            Global $EndDate = GUICtrlRead($Inputdt2)
            Global $EndTime = GUICtrlRead($Inputtm2)

          Global $Appt = _OL_RecipientFreeBusyGet($OOutlook, $Path, $StartDate, $iMinPerChar, $bCompleteFormat)

            MsgBox(0x40000000, 0,'get appointment ' &$Appt)
        _OL_Close($oOutlook)
    EndSwitch
WEnd

 

I am unable to interpret the results as it only gives 0's or 1's. I found that 0 character stands for Free and 1 for Tentative.My question is from what period to what period is this calculation done?

Can you please help me here?

Thanks,

Vishnu

 

Edited August 25, 2015 by VishnuNair
edit

[water]

According to the docu in the UDF:
"The default is to return a string representing one month of free/busy information."

[VishnuNair]

Wow!! One month that is a lot.

Is there anyway i can use the same script to return the value for a specific time frame for example 26th August 2015 @ 8:00 am?

Is this possible? Or use some other function?

[water]

You can only specify the start date/time plus the granularity (means the number of minutes each returned character stands for).
For examples please check _OL_RecipientFreeBusyGet.au3

[VishnuNair]

Thank you very much Water. I used the function and it worked fine

Thank you very much..Have a great day!!

[water]