Outlook 2003 create appointment

[cookiemonster]

Yeh it appears in both calendars, any idea why its creating it as a second calendar? is there any way to stop this from happening?

[cookiemonster]

Ah ok I can remove the 'On-Call' calendar as its just duplicated it but putting 'Calendar - ' at the start.

Now I get it i think, do you know why its put 'Calendar - ' at the start of the name though?

[water]

Seems to be default Outlook behavior

[cookiemonster]

yeh very odd, but oh well doesnt matter too much, cheers for sussing that out! I think il be shouting for help soon enough again, so i want to do 

_OL_FolderAccess.au3

_OL_ItemCreate.au3

_OL_ItemRecipientAdd.au3

Is that right?

[water]

Looks good. You will find some information about how to create an appointment in the wiki.

[cookiemonster]

Yeh ive got a autoit script already that uses _OL_Wrapper_CreateAppointment but to do this new tool I need to use 

_OL_FolderAccess.au3

_OL_ItemCreate.au3

_OL_ItemRecipientAdd.au3

 

 or could I use

_OL_FolderAccess.au3

_OL_Wrapper_CreateAppointment

_OL_ItemRecipientAdd.au3

[water]

Approach number 1 is needed. _OL_Wrapper_CreateAppointment doesn't accept the folder parameter.

[cookiemonster]

ah ok cheers

[cookiemonster]

ok got stuck at this point now...

Getting @extended = 1;  |1 - $iFolderType is missing or not a number

Where would I set this? and where do I find what I need to set it to?

[water]

Looks like you miss $olFolderCalendar as in the example of post #58.

[cookiemonster]

Nope thats there 

#AutoIt3Wrapper_AU3Check_Parameters= -d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6
#AutoIt3Wrapper_AU3Check_Stop_OnWarning=Y
#include <OutlookEX.au3>

Global $oOutlook = _OL_Open()

Global $aFolder = _OL_FolderAccess($oOutlook, "\\On-Call\", $olFolderCalendar)

If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_FolderAccess Example Script", "Error accessing folder '\\On-Call'. @error = " & @error)
Global $aFolderDisplay[6][2] = [[$aFolder[0]],["","Folder object"],["","Default item type for the folder"],["", "StoreID where the folder resides"],["", "EntryID of the folder"],["", "Folder path"]]
$aFolderDisplay[1][0] = $aFolder[1]
$aFolderDisplay[2][0] = $aFolder[2]
$aFolderDisplay[3][0] = $aFolder[3]
$aFolderDisplay[4][0] = $aFolder[4]
$aFolderDisplay[5][0] = $aFolder[5]
_ArrayDisplay($aFolderDisplay, "Folder '\\On-Call\' successfully accessed.")

$oItem = _OL_ItemCreate($oOutlook, $olAppointmentItem, "\\On-Call\", "", "Subject=TestSubject", "Start=" & _NowCalc(), "End=" & _DateAdd("h", 3, _NowCalc()), _
        "Location=Building A, Room 10", "RequiredAttendees=" & $oOutlook.GetNameSpace("MAPI" ).CurrentUser.Name)
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_ItemCreate Example Script", "Error creating an appointment in folder '\\On-Call\'. @error = " & @error & ", @extended = " & @extended)

_OL_Close($oOutlook)

So I get the last error box "Error creating an appointment in folder 'On-Call'. @error = 1, @extended = 1"

[water]

_OL_FolderAccess returns an array. Element 1 contains the folder object. Pass this object to _OL_ItemCreate.

$oItem = _OL_ItemCreate($oOutlook, $olAppointmentItem, $aFolder[1], "", "Subject=TestSubject", "Start=" & _NowCalc(), "End=" & _DateAdd("h", 3, _NowCalc()), _
        "Location=Building A, Room 10", "RequiredAttendees=" & $oOutlook.GetNameSpace("MAPI" ).CurrentUser.Name)

[cookiemonster]

 

_OL_FolderAccess returns an array. Element 1 contains the folder object. Pass this object to _OL_ItemCreate.

$oItem = _OL_ItemCreate($oOutlook, $olAppointmentItem, $aFolder[1], "", "Subject=TestSubject", "Start=" & _NowCalc(), "End=" & _DateAdd("h", 3, _NowCalc()), _
        "Location=Building A, Room 10", "RequiredAttendees=" & $oOutlook.GetNameSpace("MAPI" ).CurrentUser.Name)

Ah that I now understand, I did think surly it needs to be passed into it but for some silly reason didnt think of putting it it there like that. thats now working so going to look at putting in the required attendees now

[water]

Do you just want to create an appointment with some attendees or do you want to send a meeting request to the attendees?

[cookiemonster]

An appointment with attendees so it also goes into their calendar too

[cookiemonster]

think im heading in the right direction with this:

Global $oOutlook = _OL_Open()
Global $aFolder = _OL_FolderAccess($oOutlook, "\\On-Call\", $olFolderCalendar)
Global $oItem = _OL_ItemCreate($oOutlook, $olAppointmentItem, $aFolder[1], "", "Subject=TestSubject", "Start=" & _NowCalc(), "End=" & _DateAdd("h", 3, _NowCalc()), _
        "Location=Building A, Room 10", "RequiredAttendees=" & $oOutlook.GetNameSpace("MAPI" ).CurrentUser.Name)


_OL_ItemRecipientAdd($oOutlook, $oItem, Default, $olTo, "James Quinn")


If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_ItemCreate Example Script", "Error creating an appointment in folder '\\On-Call\'. @error = " & @error & ", @extended = " & @extended)


_OL_Close($oOutlook)

[water]

Add

"MeetingStatus=1"

to _OL_ItemCreate. This changes the appointment to a meeting request.

When finished use

_OL_ItemSend($oOutlook, $oItem)

to send the meeting request.to the attendees.

[cookiemonster]

Yep it all seems to work, is there a way to force the attendees as going rather than giving them the option to decline?

[water]

Not that I know of. I think that's what a meeting request is for. If the attendee has an important meeting with the boss, is sick or on vacation he has to be able to decline.

[cookiemonster]

Yeh guess that makes sense.