Jump to content

OutlookEX UDF - Help & Support (II)


water
 Share

Recommended Posts

If you run the script as ordinary user the problem goes away?

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

I think I will add a section to the wiki about debugging :)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

hi, does anybody know what is the OlItemType for meeting response?

We have following scenario in our project:

1.userA send meeting invitation to userB

2.userB accept the meeting

3.userA check meeting response

For step 3, I use following code to get the meeting response, but can not find the item

_OL_ItemFind($oOL, "*Inbox", $olMailItem, "[subject]='" & $sSubject & "'","","","EntryID")

I also tried to get the response with $olNoteItem and $OlPostItem, neither works....

Link to comment
Share on other sites

I wouldn't check the responses but the status of the recipients of the meeting.

Something like:

For $oRecipient in $oMeeting.Recipients
    ConsoleWrite("Status of recipient: " & $oRecipient.Name & ", Status: " & $oRecipient.MeetingResponseStatus)
Next

The MeetingResponseStatus enumeration can be found here.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

I think you need to search for one of this object classes:

Global Const $olMeetingResponseNegative = 55 ; Represents a MeetingItem object that is a refusal of a meeting request
Global Const $olMeetingResponsePositive = 56 ; Represents a MeetingItem object that is an acceptance of a meeting request
Global Const $olMeetingResponseTentative = 57

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Hi

I want to reschedule one instance of daily repeating meeting.

for example, there are 5 days daily repeating meeting, starts on Monday, I will reschedule the instance on Thursday.

But it seems that _OL_ItemRecurrenceSet can't reschedule one instance.

I want to use _OL_ItemFind to get the instance on Thursday, but always get error, can't find the instance.

Could you please help me this? do you have idear?

Thank you.

Link to comment
Share on other sites

Please have a look at function

_OL_ItemRecurrenceExceptionSet: Defines an exception in the recurrence information of an item (appointment or task).

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

:)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Hi water

A long time ago you suggested an amendment to _OL_ItemAttachmentGet that would pick up the type of attachment flag and if the attachment was hidden (code below):

Func _OL_ItemAttachmentGet($oOL, $vOL_Item, $sOL_StoreID = Default)

    Local $PR_ATTACH_FLAGS = "<a href='http://schemas.microsoft.com/mapi/proptag/0x37140003' class='bbc_url' title='External link' rel='nofollow external'>http://schemas.microsoft.com/mapi/proptag/0x37140003"</a>
    Local $PR_ATTACHMENT_HIDDEN = "<a href='http://schemas.microsoft.com/mapi/proptag/0x7FFE000B' class='bbc_url' title='External link' rel='nofollow external'>http://schemas.microsoft.com/mapi/proptag/0x7FFE000B"</a>
    If Not IsObj($vOL_Item) Then
        If StringStripWS($vOL_Item, 3) = "" Then Return SetError(1, 0, 0)
        $vOL_Item = $oOL.Session.GetItemFromID($vOL_Item, $sOL_StoreID)
        If @error Then Return SetError(2, @error, 0)
    EndIf
    If $vOL_Item.Attachments.Count = 0 Then Return SetError(3, 0, 0)
    Local $aOL_Attachments[$vOL_Item.Attachments.Count + 1][9] = [[$vOL_Item.Attachments.Count, 9]]
    Local $iOL_Index = 1
    For $oOL_Attachment In $vOL_Item.Attachments
        $aOL_Attachments[$iOL_Index][0] = $oOL_Attachment
        $aOL_Attachments[$iOL_Index][1] = $oOL_Attachment.DisplayName
        $aOL_Attachments[$iOL_Index][2] = $oOL_Attachment.FileName
        $aOL_Attachments[$iOL_Index][3] = $oOL_Attachment.PathName
        $aOL_Attachments[$iOL_Index][4] = $oOL_Attachment.Position
        $aOL_Attachments[$iOL_Index][5] = $oOL_Attachment.Size
        $aOL_Attachments[$iOL_Index][6] = $oOL_Attachment.Type
        $aOL_Attachments[$iOL_Index][7] = $oOL_Attachment.PropertyAccessor.GetProperty($PR_ATTACH_FLAGS)
        $aOL_Attachments[$iOL_Index][8] = $oOL_Attachment.PropertyAccessor.GetProperty($PR_ATTACHMENT_HIDDEN)
        $iOL_Index += 1
    Next
    Return $aOL_Attachments

EndFunc   ;==>_OL_ItemAttachmentGet

When adding this code back in to OutlookEX.au3 i get a syntax error relating to the quotes around the Local $PR_ATTACH_FLAGS and Local $PR_ATTACHMENT_HIDDEN lines, so i moved the quotes to the other side of the </a> tag, which removes the syntax error.  However, even when I do that $aOL_Attachments[$iOL_Index][7] and $aOL_Attachments[$iOL_Index][8] are not being populated with any information.

Could you help?

Link to comment
Share on other sites

water

I fixed it myself by changing

Local $PR_ATTACH_FLAGS = "<a href='http://schemas.microsoft.com/mapi/proptag/0x37140003' class='bbc_url' title='External link' rel='nofollow external'>http://schemas.microsoft.com/mapi/proptag/0x37140003"</a>
Local $PR_ATTACHMENT_HIDDEN = "<a href='http://schemas.microsoft.com/mapi/proptag/0x7FFE000B' class='bbc_url' title='External link' rel='nofollow external'>http://schemas.microsoft.com/mapi/proptag/0x7FFE000B"</a>

to be

Local $PR_ATTACH_FLAGS = "http://schemas.microsoft.com/mapi/proptag/0x37140003"
Local $PR_ATTACHMENT_HIDDEN = "http://schemas.microsoft.com/mapi/proptag/0x7FFE000B"
Link to comment
Share on other sites

Looks like this was a copy&paste problem. "bbc_url" looks like a bulleting board tag.

Glad you could solve it yourself :)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Hi water,

I want to catch the COM error, or COM error doesnt' write into stream.

do you have some idea?

Thank you.

COM Error Encountered in test.au3
OutlookEx UDF version = 0.9.0
@AutoItVersion = 3.3.8.1
@AutoItX64 = 0
@Compiled = 0
@OSArch = X64
@OSVersion = WIN_7
Scriptline = 89
NumberHex = 80020009
Number = -2147352567
WinDescription =
Description = You changed one of the recurrences of this item, and this instance no longer exists. Close any open items and try again.
Source = Microsoft Outlook
HelpFile =
HelpContext = 0
LastDllError = 0
========================================================

Link to comment
Share on other sites

Glad you like the UDF :D

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

i am trying to get all the distribution lists a person is a member of... _OL_DistListMemberOf i think does just that =)

however i am having difficulty figuring out what to pass through as $oExchangeUser.  help section says "Resolved object of an Exchange user as returned by _OL_ItemRecipientCheck" which ive tried but no dice

#include <array.au3>
#include <outlookex.au3>
 
$msg_normal = 0
 
$oOutlook = _OL_Open()
 
$aRecipient = _OL_ItemRecipientCheck($oOutlook, @UserName) ;this returns an array of 7 columns but none of them work in _OL_DistListMemberOf
 
$dist_lists = _OL_DistListMemberOf($aRecipient[1][6])
 
_OL_Close($oOutlook)
 
debug($dist_lists)
 
Func Debug($variable1 = "", $variable2 = "", $variable3 = "")
 
If IsArray($variable1) Then
_ArrayDisplay($variable1)
Else
If $variable2 <> "" Then
$variable1 &= @CRLF & $variable2
EndIf
 
If $variable3 <> "" Then
$variable1 &= @CRLF & $variable3
EndIf
 
ClipPut($variable1)
MsgBox($msg_normal, "Debug", $variable1)
EndIf
 
EndFunc   ;==>Debug

 

Thanks in advance!

Link to comment
Share on other sites

Check the example script for _OL_DistListMemberOf.

This are the relevant lines:

Global $avUser = _OL_ItemRecipientCheck($oOutlook, $oOutlook.Session.CurrentUser.Name) ; Resolve Current User Name
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_DistListMemberOf Example Script", "Error resolving the current user. @error = " & @error & ", @extended = " & @extended)
Global $Result = _OL_DistListMemberOf($avUser[1][2])

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...