water Posted November 27, 2013 Author Share Posted November 27, 2013 Can you please post the _OL_Wrapper_CreateAppointment statement including all parameters? 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...
lolipop Posted November 27, 2013 Share Posted November 27, 2013 Hi water, I'm trying to export Outlook 2010 Global Address List to text or csv file. Can I know whether this UDF able to do it? Thanks. Link to comment Share on other sites More sharing options...
water Posted November 27, 2013 Author Share Posted November 27, 2013 In short: Yes. Longer: Run _OL_AddressListGet to determine the GAL. Element 0 of the 2d array is set to = $olExchangeGlobalAddressList for a GAL. Use _OL_AddressListMemberGet to get all members of the GAL.See the example script for _OL_AddressListMemberGet. 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 November 28, 2013 Share Posted November 28, 2013 Hi Water, here is the script I used to create repeating appointment #include <OutlookEx.au3> Global $oOutlook = _OL_Open() If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended) ; ***************************************************************************** ; Example 1 ; Create an appointment and set recurrence properties. ; ***************************************************************************** Global $sCurrentUser = $oOutlook.GetNameSpace("MAPI").CurrentUser.Name Global $sStart = StringLeft(_Nowcalc(),16) Global $sEnd = StringLeft(_DateAdd("h", 3, _NowCalc()), 16) _OL_Wrapper_CreateAppointment($oOutlook, "TestMeeting12345", $sStart, $sEnd, "My office", False, "Testbody", _ 15, $olBusy, $olImportanceHigh, $olPrivate, $olRecursWeekly, $sStart, _DateAdd("w", 3, $sEnd), 1) If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OutlookCreateAppointment Wrapper Script", "Error creating appointment. @error = " & @error & ", @extended: " & @extended) MsgBox(64, "OutlookEX UDF: _OutlookCreateAppointment Wrapper Script", "Appointment successfully created '" & $sCurrentUser & "'!") _OL_Close($oOutlook) Link to comment Share on other sites More sharing options...
water Posted November 28, 2013 Author Share Posted November 28, 2013 When you manually create the same appointment and then have a look at the XML, what is different? I can't test here because of not having access to our servers. But I miss the "private" setting in your XML file. 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...
Tjalve Posted November 29, 2013 Share Posted November 29, 2013 Hi. I have successfully used this UDF befor, but now i cant get it to work. I cant even get _OL_Open() to work. The function itself return: 0 = Fail But both @extended and @error also return 0. #include <outlookEX.au3> #include <array.au3> $oOutlook = _OL_Open() ConsoleWrite("Outlook: " & $oOutlook & @CRLF) ConsoleWrite("Error: " & @error & @CRLF) ConsoleWrite("Extended: " & @extended & @CRLF) _OL_Close($oOutlook) Im running Office 2010 32bit Swedish on Windows 8.1 Eng Link to comment Share on other sites More sharing options...
water Posted November 29, 2013 Author Share Posted November 29, 2013 Which version of the OutlookEX UDF do 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...
water Posted November 29, 2013 Author Share Posted November 29, 2013 I just noticed that your first ConsoleWrite function call overwrites the values for @error and extended. Try this one to get correct values: #include <outlookEX.au3> #include <array.au3> $oOutlook = _OL_Open() ConsoleWrite("Outlook: " & IsObj($oOutlook) & @CRLF & "Error: " & @error & @CRLF & "Extended: " & @extended & @CRLF) _OL_Close($oOutlook) 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...
Tjalve Posted December 2, 2013 Share Posted December 2, 2013 I just noticed that your first ConsoleWrite function call overwrites the values for @error and extended. Try this one to get correct values: #include <outlookEX.au3> #include <array.au3> $oOutlook = _OL_Open() ConsoleWrite("Outlook: " & IsObj($oOutlook) & @CRLF & "Error: " & @error & @CRLF & "Extended: " & @extended & @CRLF) _OL_Close($oOutlook) You are correct of course. So i remade the script: #include <outlookEX.au3> #include <array.au3> $oOutlook = _OL_Open() ConsoleWrite("Outlook: " & $oOutlook & " Error: " & @error & " Extended: " & @extended & @CRLF) This time i get: Outlook: 0 Error: 1 Extended: -2146959355 Link to comment Share on other sites More sharing options...
water Posted December 2, 2013 Author Share Posted December 2, 2013 @error = 1 means: Unable to create Outlook Object Are you sure Outlook is installed on this client? Is it a full or just a trial version? 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...
Tjalve Posted December 3, 2013 Share Posted December 3, 2013 @error = 1 means: Unable to create Outlook Object Are you sure Outlook is installed on this client? Is it a full or just a trial version? Yes. Its a fully licensed copy of Office 2010. Outlook is always running. Link to comment Share on other sites More sharing options...
water Posted December 3, 2013 Author Share Posted December 3, 2013 I have noticed that - after you have upgraded a trial version to a full version - COM support is still missing. Uninstalling and installing the full version is needed in that case. 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...
Tjalve Posted December 3, 2013 Share Posted December 3, 2013 I have noticed that - after you have upgraded a trial version to a full version - COM support is still missing. Uninstalling and installing the full version is needed in that case. As far as i know, this is a full install of office and it never was a trial version (again, as far as i know). Is there a way that i can check/install COM support? Link to comment Share on other sites More sharing options...
water Posted December 3, 2013 Author Share Posted December 3, 2013 To get more detailed error information please insert the following line before _OL_Open: _OL_ErrorNotify(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 More sharing options...
Tjalve Posted December 3, 2013 Share Posted December 3, 2013 To get more detailed error information please insert the following line before _OL_Open: _OL_ErrorNotify(2) OutlookEx UD Version = 0.10.0 AutoitVersion = 3.3.8.1 AutoitX64 = 0 Copiled = 0 OSArcgh = X64 OSVersion = Win8 Scriptline = 194 NumberHex = 800401E3 Number = -2147221021 WinDesciption = Operation Unavailible Description = Source = HelpFile = HelpContext = 0 LastDllError = 0 Link to comment Share on other sites More sharing options...
water Posted December 3, 2013 Author Share Posted December 3, 2013 Is Outlook already running when this error occurres? 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...
Tjalve Posted December 3, 2013 Share Posted December 3, 2013 Is Outlook already running when this error occurres? Yes it is. Link to comment Share on other sites More sharing options...
water Posted December 3, 2013 Author Share Posted December 3, 2013 Strange. If Outlook is running then line 194 should never be executed. 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 December 3, 2013 Author Share Posted December 3, 2013 Do you run the Autoit script with admin permissions (#RequireAdmin)? It seems that the process that starts or hooks into Outlook needs to be run with the same permissions as Outlook. 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...
Tjalve Posted December 3, 2013 Share Posted December 3, 2013 Do you run the Autoit script with admin permissions (#RequireAdmin)? It seems that the process that starts or hooks into Outlook needs to be run with the same permissions as Outlook. Ahh there we go. I always run as Admin becuase you get ALOT of access issues in Windows 8 if you dont. I guess there is no way around it huh? Link to comment Share on other sites More sharing options...
Recommended Posts