Jump to content

Recommended Posts

Posted
#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

Posted

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
Posted

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

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png 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 columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Posted
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

 

 

Posted

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)

 

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

 

Posted
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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...