OutlookEX UDF - Find Items - Revision history

Water at 09:25, 27 July 2023

2023-07-27T09:25:01Z

← Older revision		Revision as of 09:25, 27 July 2023
Line 1:		Line 1:
	[[Category:UDF]]		[[Category:UDF]]
			[[Category:Outlook]]
	Here you'll find detailed information on how to find items which then can be processed by further functions.		Here you'll find detailed information on how to find items which then can be processed by further functions.
	== Function _OL_ItemFind ==		== Function _OL_ItemFind ==

Water at 08:47, 4 January 2021

2021-01-04T08:47:57Z

← Older revision		Revision as of 08:47, 4 January 2021
Line 30:		Line 30:
	::See: http://msdn.microsoft.com/en-us/library/cc513841.aspx - "Searching Outlook Data" or http://msdn.microsoft.com/en-us/library/bb220369(v=office.12).aspx - "Items.Restrict Method"		::See: http://msdn.microsoft.com/en-us/library/cc513841.aspx - "Searching Outlook Data" or http://msdn.microsoft.com/en-us/library/bb220369(v=office.12).aspx - "Items.Restrict Method"
	:<b>N.B.:</b>		:<b>N.B.:</b>
	:Pass time as HH:MM, HH:MM:SS is invalid and returns no result.		<UL>
	:Some properties can't be used in a filter (e.g. Body, Categories, HTMLBody) and will cause an error. Please check the "Items.Restrict Method" link above.		:<LI>Pass time as HH:MM, HH:MM:SS is invalid and returns no result.
			:<LI>It seems that Outlook interprets the format of a passed date. 2020-04-01 will not be used as first of April but 4th of January. Pass the date as 01-04-2020 to make sure you get the desired result.
			:<LI>Some properties can't be used in a filter (e.g. Body, Categories, HTMLBody) and will cause an error. Please check the "Items.Restrict Method" link above.
			</UL>

	;$sSearchName (Optional)		;$sSearchName (Optional)

Water: /* Function _OL_ItemFind */

2021-01-04T08:28:35Z

Function _OL_ItemFind

← Older revision		Revision as of 08:28, 4 January 2021
Line 64:		Line 64:
	:''@ItemObject'' - Object of the item that matches the search criteria		:''@ItemObject'' - Object of the item that matches the search criteria
	You can access all available properties and methods of an item by using this two objects.		You can access all available properties and methods of an item by using this two objects.

			=== Issues ===
			When the returned array holds references to an item (e.g. @FolderObject, @ItemObject) not all data might be returned. This could be caused by a limit the Exchange admin has set for the number of items you can open simultaneously.</br>You might get the following error message: ''Your server administrator has limited the number of items you can open simultaneously.''</br>
			Details can be found [https://www.autoitscript.com/forum/topic/158418-outlookex-udf-help-support-iii/?do=findComment&comment=1324241 here].

Water: /* Pseudo properties */

2021-01-04T08:13:10Z

Pseudo properties

← Older revision		Revision as of 08:13, 4 January 2021
Line 63:		Line 63:
	:''@FolderObject'' - Object of the folder where the item resides. Helpful when searching subfolders.		:''@FolderObject'' - Object of the folder where the item resides. Helpful when searching subfolders.
	:''@ItemObject'' - Object of the item that matches the search criteria		:''@ItemObject'' - Object of the item that matches the search criteria
	You can ~~use~~ all available properties and methods ~~for those~~ two objects.		You can access all available properties and methods of an item by using this two objects.

Water: Added pseudo properties

2020-12-15T16:37:42Z

Added pseudo properties

← Older revision		Revision as of 16:37, 15 December 2020
Line 41:		Line 41:

	;$sReturnProperties (Optional)		;$sReturnProperties (Optional)
	:Comma separated list of properties to return (default = depending on $iObjectClass). Be sure to specify the properties in correct case e.g. "FirstName" is valid, "Firstname" is invalid.		:Comma separated list of properties to return (default = depending on $iObjectClass). Be sure to specify the properties in correct case e.g. "FirstName" is valid, "Firstname" is invalid.</br>
			:For pseudo properties please see the next section.

	;$sSort (Optional)		;$sSort (Optional)
	:The name of the property by which to sort, which may be enclosed in brackets, for example, "[CompanyName]". User-defined properties that contain spaces must be enclosed in brackets. After the property the optional string "True" to sort descending (default = None) might follow. E.g. "[Subject], True" sorts the result descending on the subject.		:The name of the property by which to sort, which may be enclosed in brackets, for example, "[CompanyName]".
			:User-defined properties that contain spaces must be enclosed in brackets. After the property the optional string "True" to sort descending (default = None) might follow.
			:E.g. "[Subject], True" sorts the result descending on the subject.

	;$iFlags (Optional)		;$iFlags (Optional)
Line 54:		Line 57:
	;$sWarningClick (Optional)		;$sWarningClick (Optional)
	:The entire path (drive, directory, file name and extension) to 'OutlookWarning2.exe' or another exe with the same function (default = None)		:The entire path (drive, directory, file name and extension) to 'OutlookWarning2.exe' or another exe with the same function (default = None)

			=== Pseudo properties ===
			Some properties can't be accessed by their name using parameter $sReturnProperties.</br>
			That's why the following pseudo properties have been implemented:
			:''@FolderObject'' - Object of the folder where the item resides. Helpful when searching subfolders.
			:''@ItemObject'' - Object of the item that matches the search criteria
			You can use all available properties and methods for those two objects.

Water at 19:50, 3 October 2016

2016-10-03T19:50:13Z

← Older revision		Revision as of 19:50, 3 October 2016
Line 1:		Line 1:
	[[Category:~~OutlookEX_UDF~~]]		[[Category:UDF]]
	Here you'll find detailed information on how to find items which then can be processed by further functions.		Here you'll find detailed information on how to find items which then can be processed by further functions.
	== Function _OL_ItemFind ==		== Function _OL_ItemFind ==

Rt01: Updated parameter names

2013-02-23T10:36:57Z

Updated parameter names

← Older revision		Revision as of 10:36, 23 February 2013
Line 9:		Line 9:
	:Outlook object returned by a preceding call to _OL_Open()		:Outlook object returned by a preceding call to _OL_Open()

	;$~~oOL_Folder~~		;$vFolder
	:Folder object as returned by _OL_FolderAccess or full name of folder where the search will be started. If you want to search a default folder you have to specify the folder object.		:Folder object as returned by _OL_FolderAccess or full name of folder where the search will be started. If you want to search a default folder you have to specify the folder object.

	;$~~iOL_ObjectClass~~ (Optional)		;$iObjectClass (Optional)
	:Class of items to search for. Defined by the Outlook OlObjectClass enumeration (default = $olContact). Examples:		:Class of items to search for. Defined by the Outlook OlObjectClass enumeration (default = $olContact). Examples:
	:''$olAppointment'' - Represents an AppointmentItem object		:''$olAppointment'' - Represents an AppointmentItem object
Line 19:		Line 19:
	:''$olTask'' - Represents a TaskItem object		:''$olTask'' - Represents a TaskItem object

	;$~~sOL_Restrict~~ (Optional)		;$sRestrict (Optional)
	:Filter text to restrict number of items returned (exact match). Can be combined with $~~sOL_SearchName~~/$~~sOL_Search~~. The filter can be a Jet query or a DASL query with the @SQL= prefix (which isn't described here).		:Filter text to restrict number of items returned (exact match). Can be combined with $sSearchName/$sSearch. The filter can be a Jet query or a DASL query with the @SQL= prefix (which isn't described here).
	:Jet query language syntax:		:Jet query language syntax:

Line 33:		Line 33:
	:Some properties can't be used in a filter (e.g. Body, Categories, HTMLBody) and will cause an error. Please check the "Items.Restrict Method" link above.		:Some properties can't be used in a filter (e.g. Body, Categories, HTMLBody) and will cause an error. Please check the "Items.Restrict Method" link above.

	;$~~sOL_SearchName~~ (Optional)		;$sSearchName (Optional)
	:Specify the name of a single property to be searched for the value specified by $~~sOL_SearchValue~~ (partial match). Can be combined with $~~sOL_Restrict~~.		:Specify the name of a single property to be searched for the value specified by $sSearchValue (partial match). Can be combined with $sRestrict.
	:Be sure to specify the property in correct case e.g. "FirstName" is valid, "Firstname" is invalid.		:Be sure to specify the property in correct case e.g. "FirstName" is valid, "Firstname" is invalid.

	;$~~sOL_SearchValue~~ (Optional)		;$sSearchValue (Optional)
	:String value to search for. All items are returned where the string can be found at any position of the property e.g. if property "Subject" has the value of "This is a test" then the item will be found if $~~sOL_SearchValue~~ is "This" or "is a" or "test".		:String value to search for. All items are returned where the string can be found at any position of the property e.g. if property "Subject" has the value of "This is a test" then the item will be found if $sSearchValue is "This" or "is a" or "test".

	;$~~sOL_ReturnProperties~~ (Optional)		;$sReturnProperties (Optional)
	:Comma separated list of properties to return (default = depending on $~~iOL_ObjectClass~~). Be sure to specify the properties in correct case e.g. "FirstName" is valid, "Firstname" is invalid.		:Comma separated list of properties to return (default = depending on $iObjectClass). Be sure to specify the properties in correct case e.g. "FirstName" is valid, "Firstname" is invalid.

	;$~~sOL_Sort~~ (Optional)		;$sSort (Optional)
	:The name of the property by which to sort, which may be enclosed in brackets, for example, "[CompanyName]". User-defined properties that contain spaces must be enclosed in brackets. After the property the optional string "True" to sort descending (default = None) might follow. E.g. "[Subject], True" sorts the result descending on the subject.		:The name of the property by which to sort, which may be enclosed in brackets, for example, "[CompanyName]". User-defined properties that contain spaces must be enclosed in brackets. After the property the optional string "True" to sort descending (default = None) might follow. E.g. "[Subject], True" sorts the result descending on the subject.

	;$~~fOL_Flags~~ (Optional)		;$iFlags (Optional)
	:Flags to set different processing options. Can be a combination of the following:		:Flags to set different processing options. Can be a combination of the following:
	:''1'' - Subfolders will be included		:''1'' - Subfolders will be included
	:''2'' - Row 1 contains column headings. Therefore the number of rows/columns in the table has to be calculated using UBound		:''2'' - Row 1 contains column headings. Therefore the number of rows/columns in the table has to be calculated using UBound
	:''4'' - Just return the number of records. You don't get an array, just a single integer denoting the total number of records found		:''4'' - Just return the number of records. You don't get an array, just a single integer denoting the total number of records found

			;$sWarningClick (Optional)
			:The entire path (drive, directory, file name and extension) to 'OutlookWarning2.exe' or another exe with the same function (default = None)

IEvKI3gv9Wrkd41u: +Category:OutlookEX_UDF

2013-01-21T12:57:54Z

+Category:OutlookEX_UDF

← Older revision		Revision as of 12:57, 21 January 2013
Line 1:		Line 1:
			[[Category:OutlookEX_UDF]]
	Here you'll find detailed information on how to find items which then can be processed by further functions.		Here you'll find detailed information on how to find items which then can be processed by further functions.
	== Function _OL_ItemFind ==		== Function _OL_ItemFind ==

Rt01: WIP - Work in Progress - removed

2012-02-13T22:02:50Z

WIP - Work in Progress - removed

New page

Here you'll find detailed information on how to find items which then can be processed by further functions.
== Function _OL_ItemFind ==
Finds items (contacts, appointments ...) in the specified folder (and - optional - any subfolder) and returns the requested properties of the found items in an array.
=== Parameters ===
The following parameters define what is searched for and what properties are returned by the function:

;$oOL
:Outlook object returned by a preceding call to _OL_Open()

;$oOL_Folder
:Folder object as returned by _OL_FolderAccess or full name of folder where the search will be started. If you want to search a default folder you have to specify the folder object.

;$iOL_ObjectClass (Optional)
:Class of items to search for. Defined by the Outlook OlObjectClass enumeration (default = $olContact). Examples:
:''$olAppointment'' - Represents an AppointmentItem object
:''$olContact'' - Represents a ContactItem object
:''$olMail'' - Represents a MailItem object
:''$olTask'' - Represents a TaskItem object

;$sOL_Restrict (Optional)
:Filter text to restrict number of items returned (exact match). Can be combined with $sOL_SearchName/$sOL_Search. The filter can be a Jet query or a DASL query with the @SQL= prefix (which isn't described here).
:Jet query language syntax:

::''Restrict filter:'' Filter LogicalOperator Filter ...
::''LogicalOperator:'' And, Or, Not. Use ( and ) to change the processing order
::''Filter:'' "[property] operator 'value'" or '[property] operator "value"'
::''Operator:'' <, >, <=, >=, <>, =
::''Example:'' "[Start]='2011-02-21 08:00' And [End]='2011-02-21 10:00' And [Subject]='Test'"
::See: http://msdn.microsoft.com/en-us/library/cc513841.aspx - "Searching Outlook Data" or http://msdn.microsoft.com/en-us/library/bb220369(v=office.12).aspx - "Items.Restrict Method"
:<b>N.B.:</b>
:Pass time as HH:MM, HH:MM:SS is invalid and returns no result.
:Some properties can't be used in a filter (e.g. Body, Categories, HTMLBody) and will cause an error. Please check the "Items.Restrict Method" link above.

;$sOL_SearchName (Optional)
:Specify the name of a single property to be searched for the value specified by $sOL_SearchValue (partial match). Can be combined with $sOL_Restrict.
:Be sure to specify the property in correct case e.g. "FirstName" is valid, "Firstname" is invalid.

;$sOL_SearchValue (Optional)
:String value to search for. All items are returned where the string can be found at any position of the property e.g. if property "Subject" has the value of "This is a test" then the item will be found if $sOL_SearchValue is "This" or "is a" or "test".

;$sOL_ReturnProperties (Optional)
:Comma separated list of properties to return (default = depending on $iOL_ObjectClass). Be sure to specify the properties in correct case e.g. "FirstName" is valid, "Firstname" is invalid.

;$sOL_Sort (Optional)
:The name of the property by which to sort, which may be enclosed in brackets, for example, "[CompanyName]". User-defined properties that contain spaces must be enclosed in brackets. After the property the optional string "True" to sort descending (default = None) might follow. E.g. "[Subject], True" sorts the result descending on the subject.

;$fOL_Flags (Optional)
:Flags to set different processing options. Can be a combination of the following:
:''1'' - Subfolders will be included
:''2'' - Row 1 contains column headings. Therefore the number of rows/columns in the table has to be calculated using UBound
:''4'' - Just return the number of records. You don't get an array, just a single integer denoting the total number of records found