wese85 Posted August 20, 2021 Posted August 20, 2021 #include <OutlookEX.au3> $oOutlook = _OL_Open() If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended) $aFolder = _OL_FolderAccess($oOutlook, "", $olFolderInbox) If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_PSTAccess Example Script", "Error accessing archive folder. @error = " & @error & ", @extended: " & @extended) $aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "", "", "", "Subject,Body,SenderEmailAddress", "", 1) $iRows = (UBound($aItems, $UBOUND_ROWS)) - 1 ;i count the line of this array _ArrayDisplay($aItems, "OutlookEX UDF: _OL_ItemFind Example Script - Unread mails") ; For $i=1 To $iRows Step 1 ; _OL_ItemModify($oOutlook,$aItems[$i][0], Default, "Unread=False");passé le mail en read ; Next _OL_Close($oOutlook) i have a problem to filter the existing emails by name or string, "$sSearchName" and "$sSearchValue" don't seem to work. "$sRestrict" with '[FirstName] = "TestFirstName"' didn't work either, maybe someone else has an idea. thanks in advance
water Posted August 20, 2021 Posted August 20, 2021 Can you post the script you use to filter the mails (means: Script including the filter). Wht is the valu of @error and @extended after _OL_ItemFind? Do you get any mail items returned when you use filters? 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
Moderators Melba23 Posted August 20, 2021 Moderators Posted August 20, 2021 Moved to the appropriate forum, as the Developer General Discussion forum very clearly states: Quote General development and scripting discussions. Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums. Moderation Team Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
wese85 Posted August 23, 2021 Author Posted August 23, 2021 On 8/20/2021 at 4:17 PM, water said: Can you post the script you use to filter the mails (means: Script including the filter). Wht is the valu of @error and @extended after _OL_ItemFind? Do you get any mail items returned when you use filters? Hi, With the code example I get without filter 300 emails displayed, with filter not a single one but also no error message. I have tried many filters, here are a few examples Quote $aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "[FirstName] = 'xxxxxx'", "", "", "Subject,Body,SenderEmailAddress", "", 1) $aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "", "FirstName", "", "Subject,Body,SenderEmailAddress", "", 1) $aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "", "", "string part subject", "Subject,Body,SenderEmailAddress", "", 1) no error Quote $aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "[E-mail] = 'xxxx@xxxx.de'", "", "", "Subject,Body,SenderEmailAddress", "", 1) error 0 |extended3 Quote $aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "[Subject]=''exact designation works", "", "", "Subject,Body,SenderEmailAddress", "", 1) but i only want to search for a part of the string
water Posted August 23, 2021 Posted August 23, 2021 If you want to search for a part of the String use the following code: $aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "", "Subject", "part of the subject", "Subject,Body,SenderEmailAddress", "", 1) Skysnake 1 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
wese85 Posted August 23, 2021 Author Posted August 23, 2021 26 minutes ago, water said: If you want to search for a part of the String use the following code: $aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "", "Subject", "part of the subject", "Subject,Body,SenderEmailAddress", "", 1) perfect, thank you very much.
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