gcue Posted January 2, 2014 Share Posted January 2, 2014 in outlook i go into addressbook and type the name of the distribution list - right click distribution list.. go to properties and on the left you see Display Name Alias Name Owner Notes and on the right you see a list of members if possible i would like to pull owner(s) and notes thanks again for your help Link to comment Share on other sites More sharing options...
water Posted January 3, 2014 Author Share Posted January 3, 2014 I'm not 100% sure but I think this information is pulled from Active Directory. Owner is in property ManagedBy, Notzes might be in info or description. Could you please have a look at the corresponding AD-entry? 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 More sharing options...
water Posted January 3, 2014 Author Share Posted January 3, 2014 how would you use "$bAllDayEvent" as True? when i use true and the event is more than one day, it will only show one and not all the days. Can you please show the code you use? 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 More sharing options...
cindyzx Posted January 7, 2014 Share Posted January 7, 2014 Hi Water, I want to search the update notice for a meeting with _OL_ItemFind, what object should I use? I tried $olMeetingRequest, but it does not work Link to comment Share on other sites More sharing options...
water Posted January 7, 2014 Author Share Posted January 7, 2014 I'm not sure but I think it should be $olMeetingRequest as long as you haven't accepted the update. 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 More sharing options...
gcue Posted January 7, 2014 Share Posted January 7, 2014 I'm not 100% sure but I think this information is pulled from Active Directory. Owner is in property ManagedBy, Notzes might be in info or description. Could you please have a look at the corresponding AD-entry? that worked! thanks Link to comment Share on other sites More sharing options...
water Posted January 7, 2014 Author Share Posted January 7, 2014 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 More sharing options...
cindyzx Posted January 9, 2014 Share Posted January 9, 2014 Hi water, I'm using _OL_ItemRecipientAdd to add new invitee to a meeting. This method will send update notice to only the added invitee. But our project requires that, all attendees should get an update notice for add/remove invitee. Is there any way to do it? Link to comment Share on other sites More sharing options...
water Posted January 9, 2014 Author Share Posted January 9, 2014 Set property ForceUpdateToAllAttendees of the ApppointmentItem to True. 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 More sharing options...
satanico64 Posted January 9, 2014 Share Posted January 9, 2014 Hi here. I've just post a date problem >here (did'nt knew if it should must be posted here or in the forum, i choose general forum). I can detail here if necessary. Thanks for reading. Nicolas. Link to comment Share on other sites More sharing options...
ngrnc Posted January 14, 2014 Share Posted January 14, 2014 Hello Water, I want to use OutlookEx UDF to propose new time for one meeting, but I have no any idea about it. Could you please give some hint? If OutlookEx can't support it, what should I do using autoIt? Thank you in advance Link to comment Share on other sites More sharing options...
water Posted January 14, 2014 Author Share Posted January 14, 2014 Try function _OL_RecipientFreeBusyGet to get the free/busy times of users or a ressource. 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 More sharing options...
ngrnc Posted January 15, 2014 Share Posted January 15, 2014 Hi Maybe I can't understand your mean, _OL_RecipientFreeBusyGet function has no information about "Propose new time". Could you please give me more detail? My scenario: Invitee receives meeting invitation, he wants to "Tentative Propose new time" I have tried as following: $aItems = _OL_ItemFind($oOL, "*\Inbox", $olMeetingRequest, "[Subject]='" & $sSubject & "'", "", "", "EntryID, Subject", "", 1) Global $oEntry = $oOL.Session.GetItemFromID($aItems[1][0]) Global $oAppt = $oEntry.GetAssociatedAppointment(True) Global $oAccept = $oAppt.Respond($sResponse, True) $oAccept.PropertyAccessor.SetProperty("http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82500040", Int(292235413802824936, 2)) I used "OutlookSpy" to get "AppointmentProposedStartWhole" property is "http://schemas.microsoft.com/mapi/id/{00062002-0000-0000-C000-000000000046}/82500040" The value format should be PT_SYSTIME. But I always got "Type mismatch." error. OutlookEx UDF version = 0.9.0 @AutoItVersion = 3.3.8.1 @AutoItX64 = 0 @Compiled = 0 @OSArch = X64 @OSVersion = WIN_7 Scriptline = 66 NumberHex = 80020005 Number = -2147352571 WinDescription = Type mismatch. Description = Source = HelpFile = HelpContext = 707406378 LastDllError = 0 what should I do using autoIt? Thank you. Link to comment Share on other sites More sharing options...
water Posted January 15, 2014 Author Share Posted January 15, 2014 (edited) I see. Maybe something like this: $aItems = _OL_ItemFind($oOL, "*\Inbox", $olMeetingRequest, "[Subject]='" & $sSubject & "'", "", "", "EntryID, Subject", "", 1) Global $oEntry = $oOL.Session.GetItemFromID($aItems[1][0]) Global $oAppt = $oEntry.GetAssociatedAppointment(True) $oAppt.Start = ... ; New Start date $oAppt.Duration = ... ; New Duration if needed Global $oMeeting = $oAppt.Respond($sResponse, True) $oMeeting.Send Edited January 15, 2014 by water 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 More sharing options...
water Posted January 15, 2014 Author Share Posted January 15, 2014 If this works I can add NewStartDate and Duration as parameters to function _OL_ItemRespond. Then everything you want could be done using this function. 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 More sharing options...
ngrnc Posted January 15, 2014 Share Posted January 15, 2014 It doesn't work, Outlook only sends respond, but has no any propose infomation Link to comment Share on other sites More sharing options...
water Posted January 15, 2014 Author Share Posted January 15, 2014 I have been searching the web high and low but couldn't find a way to propose a new time for the meeting. Did you find anything that states that it can be done using COM? 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 More sharing options...
digibeetle Posted January 16, 2014 Share Posted January 16, 2014 I am using OutlookEX to get notified of a new email which is created in the Drafts folder and to open it after it is created. This is working fine as long as Outlook isn't displaying a modal dialog box (menu settings etc..) at the time of trying to open the draft email. If this is the case the script will crash: "Error: The requested action with this object has failed." I have tried to add an "if @error" after the call to _OL_ItemDisplay($oOApp, $oOL_Item) to try to catch the error but it still fails and closes the script. Any thoughts on how to handle this? Link to comment Share on other sites More sharing options...
water Posted January 16, 2014 Author Share Posted January 16, 2014 Which version of AutoIt do you run? 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 More sharing options...
mpower Posted January 20, 2014 Share Posted January 20, 2014 (edited) I'm having a problem with getting the folder structure for a PST file that's open in outlook. I have multiple pst data files open in Outlook and _OL_FolderFind($oOutlook, '*', 99, '', 1, $olMailItem) only returns the folders within the first open PST file. Is there any way to return the folders of all open PST files? Edited January 20, 2014 by mpower Link to comment Share on other sites More sharing options...
Recommended Posts