TheOne23 Posted February 5, 2019 Posted February 5, 2019 Hi MVPs and Experts, I would like to have your kind assistance to check what is wrong with below code. The below code is to mark all read mails in the specified folder as unread. Your help will be greatly appreciated. Global $oOutlook = _OL_Open() If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended) $aItems = _OL_ItemFind($oOutlook, "ronald.paggao@infosys.com\Inbox\!!! IJP\", $olMail, "[UnRead]=false", "", "", "EntryID,Subject,Body,SenderEmailAddress", "", 1) ;_ArrayDisplay($aItems) $iRows = (UBound($aItems, $UBOUND_ROWS))-1 ;MsgBox(0,"count: ",$iRows) For $i=1 To $iRows Step 1 _OL_ItemModify($oOutlook,$aItems[$i][0], Default, "Unread=True") Next
water Posted February 5, 2019 Posted February 5, 2019 What's the value of @error after _OL_ItemFind and after _OL_ItemModify? 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
Nine Posted February 5, 2019 Posted February 5, 2019 Try : Global $oItem = _OL_ItemGet($oOutlook, $aItems[1][0], Default, -1) $oItem.Unread = True Where $aItems[n][0] is EntryID. Works for me... “They did not know it was impossible, so they did it” ― Mark Twain Spoiler Block all input without UAC Save/Retrieve Images to/from Text Monitor Management (VCP commands) Tool to search in text (au3) files Date Range Picker Virtual Desktop Manager Sudoku Game 2020 Overlapped Named Pipe IPC HotString 2.0 - Hot keys with string x64 Bitwise Operations Multi-keyboards HotKeySet Recursive Array Display Fast and simple WCD IPC Multiple Folders Selector Printer Manager GIF Animation (cached) Debug Messages Monitor UDF Screen Scraping Round Corner GUI UDF Multi-Threading Made Easy Interface Object based on Tag
TheOne23 Posted February 6, 2019 Author Posted February 6, 2019 Hi Nine, I will check your script. Thank you.
water Posted February 6, 2019 Posted February 6, 2019 4 minutes ago, TheOne23 said: I got @error = 100 returned from _OL_ItemFind or _OL_ItemModify? 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
TheOne23 Posted February 6, 2019 Author Posted February 6, 2019 Hi Water, returned from _OL_ItemModify
TheOne23 Posted February 6, 2019 Author Posted February 6, 2019 Hi Water, there is no error return for _OL_ItemFind. With _OL_ItemFind it is working and i check it with _arraydisplay()
TheOne23 Posted February 6, 2019 Author Posted February 6, 2019 Hi Nine, does't work for me. But has no error at all. Tried below to check if any error is registered in @error but none. For $i=1 To $iRows Step 1 Global $oItem = _OL_ItemGet($oOutlook, $aItems[$i][0], Default, -1) if @error then MsgBox(0,"Error: ", @error) $oItem.Unread = true Next By the way what does "-1" means?
TheOne23 Posted February 6, 2019 Author Posted February 6, 2019 Hi Guys, I finally made it work now. Below is my code. Thank you so much for your time and help on this. Global $oOutlook = _OL_Open() If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended) $aItems = _OL_ItemFind($oOutlook, "ronald.paggao@infosys.com\Inbox\!!! IJP\", $olMail, "[UnRead]=false", "", "", "EntryID,Subject,Body,SenderEmailAddress", "", 1) ;_ArrayDisplay($aItems) if @error then MsgBox(0,"Error: ", @error) $iRows = (UBound($aItems, $UBOUND_ROWS))-1 For $i=1 To $iRows Step 1 _OL_ItemModify($oOutlook,$aItems[$i][0], Default, "UnRead=true") if @error then MsgBox(0,"Error: ", @error) Next Thanks Water!
water Posted February 6, 2019 Posted February 6, 2019 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
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now