OutlookEX UDF - Help & Support (II)

[hazed6809]

Posted 30 September 2013 - 05:54 PM

I am having a problem - Email will not send when Outlook is not already running.

Using the _OL_Wrapper_SendMail Example 1, everything works flawlessly. However, if Outlook is not running

 

I am having the same issue and just upgraded to 0.10.0

 

my error code is 4000 after I call it.

 

Any info,  would be appreciated.

[water]

Sorry, I can't find the thread you refer to (30 September 2013). Do you have a link?

[Juvigy]

I tried

Global $sFree = _OL_RecipientFreeBusyGet($oOutlook, "meeting room 1", "2013/11/18", 30, False)

 

and I get error :

C:Program Files (x86)AutoIt3IncludeoutlookexOutlookEX.au3 (4484) : ==> Error in expression.:
$vRecipient = $oOL.Session.CreateRecipient($vRecipient)
$vRecipient = ^ ERROR

[water]

Looks like a call to _OL_Open is missing.

[Juvigy]

$oOutlook = _OL_Open()
$sFree = _OL_RecipientFreeBusyGet($oOutlook, "RS Sofia SOV01 03FL (CONF-Berlin)" , "2013/12/12", 30, False)
MsgBox(0,"",$sFree)

$sFree is empty.

[water]

And the value of @error is?

[Juvigy]

3

[water]

This means that the recipient could not be resolved.

You need to pass the name that is displayed in the navigation pane when you open the calendar in Outlook.

[Juvigy]

That is how i do it. I tried with my own calendar too and it still doesnt work.

$oOutlook = _OL_Open()
$sFree = _OL_RecipientFreeBusyGet($oOutlook, '03FL (CONF-Berlin)' , "2013/12/12", 30, False)
MsgBox(0,@error,$sFree)

[water]

I will check with a public folder here. Stay tuned ...

[water]

As far as I understand it:

You need to resolve a recipient to retrieve the free/busy times. If a public folder has no recipient you can't access the free/busy times.

You can only access the folder and check the date for any meetings/appointments - unfortunately this is time consuming.

[Juvigy]

And by recepient you mean something like dasdasd@dad.net ? How can i check for the existing meetings/appointments ?

[water]

_OL_ItemFind. Specify properties "Start" and "End"

[Juvigy]

I cracked it - the mail smtp address of the calendat worked. Now i need to translate all the 0's and 1's to more readable content.

[water]

Great you solved the problem

 

The default is to return a string representing one month of free/busy information.

"free" is indicated by the character 0 and all other states by the character 1.

[Malkavian99]

 

Glad you got it working

As the ItemCreate function returns the object of the created itme there is no need for ItemFind.

So this should work too (untested):

Global $oOL = _OL_Open(True)
Global $oItemDList, $oItemAdd, $arrRecipients, $RecipientCounter, $MsgRecipients = "", $Result, $oItemDListFind
Global $ListLocation = "*\Contacts"
Global $DListName = "Staffing Report"

$oItemDList = _OL_ItemCreate($oOL, $olDistributionListItem, "", "", "Subject=" & $DListName)
;if @error <> 0 then Exit msgbox("","", "Error creating distribution list " & @error & " " & @extended)
If @error then Return SetError(506, @error, 0)

$arrRecipients = StringSplit($MessageRecipients, ";")
_ArrayDelete($arrRecipients, $arrRecipients[0])
$arrRecipients[0] = $arrRecipients[0] - 1

For $RecipientCounter = 1 to $arrRecipients[0]
    _OL_DistListMemberAdd($oOL, $oItemDList, Default, $arrRecipients[$RecipientCounter])
    ;if @error <> 0 Then Exit MsgBox("", "", "Error Adding Recipient " & @error & ", " & @extended)
    If @error then Return SetError(508, @error, 0)
Next

;_OL_Wrapper_SendMailDisplay($oOL, $DListName & ";", "", "", $MessageSubject, $MessageText, "", $olFormatHTML, $olImportanceHigh)
_OL_Wrapper_SendMail($oOL, $DListName, "", "", $MessageSubject, $MessageText, "", $olFormatHTML, $olImportanceHigh)

_OL_ItemDelete($oOL, $oItemDList, Default)

 

Water, I made the changes and removed the _OL_ItemFind routines and it works. Not sure what I was coding previously that was causing it not to work. 

Thanks.

[water]

You either didn't store or use the object returned by _OL_ItemCreate or you didn't replace all occurrences of the array returned by _OL_ItemFind.

Nevermind. It's working now

[Malkavian99]

Probably something along those lines.  It's working and better than it did before I think.

Thanks.

[water]

Glad to be of service

[cindyzx]

I have a problem with repeating appointment:

In our project, we are using another server instead of Exchange to get the Active Sync message from outlook

I used the example in _OL_Wrapper_CreateAppointment to create the repeating appointment. In outlook, the appointment is created correctly, but there is some problem with the active sync message, the message does not have the recurrence information, so in server side, the appointment is recognized as a single appointment

- <ApplicationData>

  <TimeZone xmlns="Calendar:">IP7//0MAaABpAG4AYQAgAFMAdABhAG4AZABhAHIAZAAgAFQAaQBtAGUAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEMAaABpAG4AYQAgAEQAYQB5AGwAaQBnAGgAdAAgAFQAaQBtAGUAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==</TimeZone>

  <DtStamp xmlns="Calendar:">20131126T071159Z</DtStamp>

  <StartTime xmlns="Calendar:">20131127T050000Z</StartTime>

  <Subject xmlns="Calendar:">TestRepeatAppointmentHawUser11758469983</Subject>

  <UID xmlns="Calendar:">040000008200E00074C5B7101A82E0080000000080B05CDAB9EACE01000000000000000010000000F81F59AA89FFC549BB2479C394ED3D27</UID>

  <Location xmlns="Calendar:">office</Location>

  <EndTime xmlns="Calendar:">20131127T060000Z</EndTime>

  <Sensitivity xmlns="Calendar:">0</Sensitivity>

  <BusyStatus xmlns="Calendar:">2</BusyStatus>

  <AllDayEvent xmlns="Calendar:">0</AllDayEvent>

  <Reminder xmlns="Calendar:">15</Reminder>

  <MeetingStatus xmlns="Calendar:">0</MeetingStatus>

  </ApplicationData>

If we create repeating appointment manually in outlook, there is no this problem...

This problem only happen to appointment, for meeting, the active sync message has the recurrence information

Is there any workaround for it?