benjbong Posted October 25, 2012 Posted October 25, 2012 Yeah, mine doesn't account for sub folders, folder type, or other users but when I fed the same parameters to _OL_FolderAccess I was getting the generic COM failure message instead of the expected outcome. It's possible I wasn't passing it correctly but I thought I would mention it to you.
water Posted October 26, 2012 Author Posted October 26, 2012 I will check ... 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
water Posted October 26, 2012 Author Posted October 26, 2012 How do you specify the name of the secondary user? I have noticed that "Firstname LastnameKalender" works whereas "firstname.lastname@company.comKalender" doesn't. 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
benjbong Posted October 26, 2012 Posted October 26, 2012 This was the call to _OL_FolderAccess I was making before Global $cal = _OL_FolderAccess($oOL, "Secondary Sourcing CalendarCalendar", $olFolderCalendar) It would fail unless I had full access permissions on the mailbox AND it was mapped as a mailbox in outlook. If i had full access permissions and disabled the automapping in outlook it would also fail. I don't have visual studio so I can't look at what the COM object looks like for either instance to be able to say what is different.
water Posted October 26, 2012 Author Posted October 26, 2012 When you say that _OL_FolderAccess fails what is the value of @error and @extended? 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
benjbong Posted November 16, 2012 Posted November 16, 2012 Sorry for the delay, the errors I was getting were @error = 1 and @extended = -2147352567 which were the generic COM error codes
water Posted November 16, 2012 Author Posted November 16, 2012 @error = 1 means that parameter $iFolderType is missing or not a number. But in this case @error has to be 0. Can you add _OL_ErrorNotify(2)at the top of your script so we can see which line throws the error? I assume you use version 0.9 of the UDF. 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
HighlanderSword Posted November 19, 2012 Posted November 19, 2012 Hello, Is it possible using thie Great UDF to create POP3 accounts ? I have Suppor groups that have hyndres of Pop3 Email accounts, and when new resourcesare added its a manual process to add these to the users outlook setup. We have all of the details on setting up the accounts, I just have not been able to determine how this task can be automated. Thoughts ? Thanks Paul
water Posted November 19, 2012 Author Posted November 19, 2012 Unfortunately this can't be done with the OutlookEX UDF. You need to create a profile manually and start Outlook with command line switches to create the account. 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
HighlanderSword Posted November 24, 2012 Posted November 24, 2012 Hello, Can you please provide an example how to move an item from the inbox to a specfied folder in an PST ? Thanks Paul
water Posted November 24, 2012 Author Posted November 24, 2012 Use _OL_FolderAccess to access the folder in your PST. Then use _OL_ItemFind or something similar to get the EntryID of the mail item you want to move. Move using _OL_ItemMove. Every function comes with an example so please have a look at _OL_Itemmove.au3. 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
HighlanderSword Posted November 24, 2012 Posted November 24, 2012 Thanks, I thought I would have to use a function that began with OL_PST_ in order to move items into that folder. The recomendation you gave works Great !!!!!
water Posted November 24, 2012 Author Posted November 24, 2012 Glad you got it working 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
pax Posted November 27, 2012 Posted November 27, 2012 Hi water! again i´ve a short question about your nice utf. Is it possible in advance to find out if a PST file is password protected or not? I'm programming a tool to backup PST files. With OL_PSTGet I read the active PST files, then write them into an array, close them with OL_PSTClose, then backup it and open it with OL_PSTAccess again. But if there is a PST-File with a password, the outlook-password promt appears and the loop is stopping. i hope there is any chance. maybe with OL_PSTGet to check out, if the PST file is password protected or not. thank you!
water Posted November 27, 2012 Author Posted November 27, 2012 Not that I know of.As described here: "Outlook Object Model has no Method to assign a Password to a PST-File".There seems to be no way to pass the password by a script to open the PST. 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
pax Posted November 27, 2012 Posted November 27, 2012 (edited) Found something in (i think) VB.NET.I dont know much about programming, but it looks like the code is searching in CRC32-Cash of the PST-File if the passwordHash is not 0. Then it should be password protected./// <summary> /// Determines whether the specified PST is password protected. /// </summary> private static bool IsPasswordProtected(PersonalStorage pst) { // If the property exists and is nonzero, then the PST file is password protected. if (pst.MessageStoreProperties.Contains(MapiPropertyTag.PR_PST_PASSWORD)) { long passwordHash = pst.MessageStoreProperties[MapiPropertyTag.PR_PST_PASSWORD].GetLong(); return passwordHash != 0; } return false; }copied from here. Edited November 27, 2012 by pax
pax Posted November 27, 2012 Posted November 27, 2012 Okay forget it. Its from a pay component for .net called Aspose.Email for .NET...
water Posted November 27, 2012 Author Posted November 27, 2012 Should be possible. This link describes how.I will have a look and provide a sample code ... 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
water Posted November 27, 2012 Author Posted November 27, 2012 Bad news! Unfortunately the code I found only works for managed code (.net). The MAPI property tags I tried return an error and Google doesn't give me more information. I fear I have run out of ideas 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
Recommended Posts