kram Posted May 28, 2013 Share Posted May 28, 2013 Hello, I was wondering if there was a way for OutlookEX to recognize group folders that are not a part of my personal Inbox, but a part of a shared "group" inbox that I and my coworkers access. I feel the limitation is Outlook itself, as you cannot set up Outlook rules that recognize anything in the group mailbox. I was hoping someone knew of a workaround or a function of OutlookEX that will do what I want. My goal is to create script that will notify me whenever an email arrives into a specific folder under the Group mailbox. Using the _OL_FolderTree function reveals every folder under my personal inbox, but does not recognize the Group box (or any of the sub folders) that I am a part of. Thank you. Link to comment Share on other sites More sharing options...
water Posted May 28, 2013 Author Share Posted May 28, 2013 _OL_FolderTree works for your group folders as well. You just have to pass the respective starting folder to the function. Events only work for your personal mailbox. To check shared folders you could either check for unread mails every x minutes or check for mails that have been received after HH:MM:SS. 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...
Neutro Posted May 28, 2013 Share Posted May 28, 2013 (edited) Hey water, I'm having a problem using the function _OL_FolderTree(). When the name of a folder contains a slash "/" or backslash "" character, these characters are translated in the array into "%2F" or "%5C". For exemple, if a folder named "Input/Output" exists in the mailbox, when you use _OL_FolderTree() on this mailbox, the array line corresponding to this folder will look like this: mailbox_namefolder_pathInput%2FOutput Do you know how can I fix this? (i mean another way rather than analysing every array rows for %2F and %5C and remplacing them by "/" and ""). Thanks in advance for your help Edited May 28, 2013 by Neutro Identify active network connections and change DNS server - Easily export Windows network settings Clean temporary files from Windows users profiles directories - List Active Directory Groups members Export content of an Outlook mailbox to a PST file - File patch manager - IRC chat connect example Thanks again for your help Water! Link to comment Share on other sites More sharing options...
water Posted May 28, 2013 Author Share Posted May 28, 2013 If you select one of this folders in outlook and then right click to check the properties you'll find the path to the folder. Do you see the encoded path there? 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...
Neutro Posted May 28, 2013 Share Posted May 28, 2013 This is what I see when I check the folder properties, and the resulting array generated by _OL_FolderTree() : Identify active network connections and change DNS server - Easily export Windows network settings Clean temporary files from Windows users profiles directories - List Active Directory Groups members Export content of an Outlook mailbox to a PST file - File patch manager - IRC chat connect example Thanks again for your help Water! Link to comment Share on other sites More sharing options...
Neutro Posted May 28, 2013 Share Posted May 28, 2013 (edited) OK I understand what you meant I tried with a subfolder and get this: So the problem is coming from Outlook itself!?! Damn you Microsoft! Well i guess the only solution to this is to look for %2F and %5C in the array and replace them so I can use the array after with _OL_FolderAccess and _OL_FolderCopy(). Edited May 28, 2013 by Neutro Identify active network connections and change DNS server - Easily export Windows network settings Clean temporary files from Windows users profiles directories - List Active Directory Groups members Export content of an Outlook mailbox to a PST file - File patch manager - IRC chat connect example Thanks again for your help Water! Link to comment Share on other sites More sharing options...
water Posted May 28, 2013 Author Share Posted May 28, 2013 If you have a backslash in the foldername how would you distinguish it from the backslash used to separate parent and child folders? I would drop using slash and backslash and use only those characters allowed when creating a windows filename. 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...
Neutro Posted May 28, 2013 Share Posted May 28, 2013 My goal is to copy the folder with "/" and "" in their names in a pst file using _OL_FolderAccess and _OL_FolderCopy. So if using the full folder path with "/" and "" does not work with these function, I guess I need to rename the folders before copying them. Thanks again water Identify active network connections and change DNS server - Easily export Windows network settings Clean temporary files from Windows users profiles directories - List Active Directory Groups members Export content of an Outlook mailbox to a PST file - File patch manager - IRC chat connect example Thanks again for your help Water! Link to comment Share on other sites More sharing options...
water Posted May 28, 2013 Author Share Posted May 28, 2013 Shouldn't be a problem if you pass the source and target folder in encoded form. 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...
Neutro Posted May 28, 2013 Share Posted May 28, 2013 (edited) So i made some test with my "Input/Output folder": _OL_FolderAccess($outlook, "mailbox_namefolder_pathinput%2FOutput") returns "" and set @error to 1 _OL_FolderAccess($outlook, "mailbox_namefolder_pathinput/Output") works Then i tested with "InputOutput" folder: _OL_FolderAccess($outlook, "mailbox_namefolder_pathInput%5COutput") returns "" and set @error to 1 _OL_FolderAccess($outlook, "mailbox_namefolder_pathInputOutput") returns "" and set @error to 1 So either way I cannot access the folders if a "" is used PS: the script i'm doing is made to backup PST files of users that sometimes have "/" or "" in their folder names. #edit : well i figured a way out I was doing a loop of every folder and every sub folder and copied them using _OL_Folder_Copy because I didn't notice it would copy even subfolders directly So now i just use _OL_Folder_Copy on first subfolder levels and it will copy subfolders inside even if their names contain "" or "/" Edited May 28, 2013 by Neutro Identify active network connections and change DNS server - Easily export Windows network settings Clean temporary files from Windows users profiles directories - List Active Directory Groups members Export content of an Outlook mailbox to a PST file - File patch manager - IRC chat connect example Thanks again for your help Water! Link to comment Share on other sites More sharing options...
water Posted May 29, 2013 Author Share Posted May 29, 2013 Glad to hear that you could solve the problem 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...
orbs Posted June 2, 2013 Share Posted June 2, 2013 hello, situation: Outlook 2010 configured for Gmail as IMAP + some local PST's. _OL_PSTGet() returns only the local PST's, and not the Gmail store. looking at _OL_PSTGet() [line 4436] i see: If StringInStr($sPath, "mspst.dll") > 0 Then for the Gmail store, the string contains "pstprx.dll" rather than "mspst.dll". if i change the line to: If StringInStr($sPath, "mspst.dll") > 0 Or StringInStr($sPath, "pstprx.dll") > 0 Then then the Gmail store is returned too. water, is there a reason for excluding pstprx.dll from the stores? i.e. is pstprx used for some non-PST identification? or is it just an overlook? (note: not yet tested on Outlook XP or 2003) PS, water, you should really open a dedicated forum for OutlookEx, rather than a chain of threads. i believe it would be easier to search and organize topics, and you definitely deserve it. Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Link to comment Share on other sites More sharing options...
water Posted June 2, 2013 Author Share Posted June 2, 2013 _OL_PSTGet is created to return all PSTs created by you. It is made to run with "older" Outlook versions (<2007). Could you please give _OL_StoreGet a try? That's the newer version made for Outlook 2007 and later. A dedicated OutlookEX forum isn't possible - they are created by the Mods. And I don't think it is sensible. We have 3 threads now: One to discuss current functionality and enhancements, one support thread (split into two because the first got too long) and a third for examples. 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...
orbs Posted June 2, 2013 Share Posted June 2, 2013 i went to _OL_PSTGet because i am going to use it on Outlook 2003 (and most probably Outlook XP too), so _OL_StoreGet is not an option. i did try it though (Outlook 2010), and it did return the Gmail store, but the file path returned empty string. i will keep the modified function for further tests on Outlook XP/2003, and for Exchange store. Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Link to comment Share on other sites More sharing options...
water Posted June 2, 2013 Author Share Posted June 2, 2013 I don't think it is sensible to directly access the PST file of the GMail mailbox. What for do you need this information? 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 June 2, 2013 Author Share Posted June 2, 2013 Google tells me that pstprx.dll is used to synchronize the PST file with your GMail account. mspst.dll is the Personal Folder/Address Book Service Provider. Should I enhance _OL_PSTGet so it returns all PST files? Or is a note that _OL_PSTGet only lists PSTs created by the user enough? 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...
orbs Posted June 2, 2013 Share Posted June 2, 2013 enhance _OL_PSTGet? your call, but i think it is expected that if a store is visually listed in Outlook, it should be returned by the function. you can add an optional parameter to the function, something like this: Func _OL_PSTGet($oOL,$bLocalOnly=True) and the condition would then be: If StringInStr($sPath, "mspst.dll") > 0 Or (Not $bLocalOnly And (StringInStr($sPath, "pstprx.dll") > 0)) Then this, i imagine, requires some testing in several environments, to validate it does not return unexpected results. as i said, i will test in Outlook XP/2003 and with Exchange. what do i need it for? i'm not going to manipulate any of the stores, but i am comparing the results returned from Outlook via COM to the data as stored in the registry. as for why i'm doing that, i will share in details when my code is working, but for now trust me on this, i do have a good enough reason (for me at least). Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Link to comment Share on other sites More sharing options...
water Posted June 2, 2013 Author Share Posted June 2, 2013 As _OL_StoreGet returns the GMail pst I think it is sensible to add the feature to _OL_PSTGet too. If your tests run successfully I will be happy to add your code to the 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...
orbs Posted June 6, 2013 Share Posted June 6, 2013 water, would you like the function _OL_ProfileGetCurrent($oOL) ? on Outlook 2007 and higher, this is a one-line call to a NameSpace.CurrentProfileName property, but for 2003 and earlier... well, the entire web says it can't be done (unless using 3rd-party add-ins, or CDO which is an additional installation). forgive me bragging, but your humble servant have got it working for Outlook XP all the way to 2013. while at it, i made some more slight improvements on my version of _OL_PSTGet(), and i confirm it works on Outlook XP all the way to 2013. also, i found that pstprx.dll is used for Exchange (native and ActiveSync), also tested. if there's any interest, i'll publish the stuff here. warning: it's definitely NOT a one-liner... Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Link to comment Share on other sites More sharing options...
water Posted June 6, 2013 Author Share Posted June 6, 2013 orbs, if your code is useful for you (and I got the impression it is), then I'm sure it can be useful for others too. I will be glad to add your functions to the UDF. Post the code here or send me a PM and I will have a look at it. Thanks for taking the time to enhance 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 Link to comment Share on other sites More sharing options...
Recommended Posts