Next version of Redemption (3.3) will support all kinds of searches
accessible in Extended MAPI, including the substring search, bit match, etc.
Contact me via the private e-mail if you want a copy of the beta.
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
Quote:
> If I have 5 items in outlook which have the following subjects (No 5
> being empty)
> 1 apple
> 2 has apple
> 3 apple is
> 4 something
> 5
> If I do the following it only returns item 1
> s = "[Subject] = """ & "Apple" & """"
> for each I in Application.ActiveExplorer.CurrentFolder.Items.Restrict(s)
> debug.print I
> next
> But what I am expecting to be returned items 1 2 and 3 but not 4 and 5
> This is restricting a folder.
> Outlook view control Restriction: -
> It can't be used, needs to be a folder restriction so the information
> can be put into an array - folder it self can't be but values can
> With the outlook view control the restriction works like (quote from
> net):
> >Note that = is not interpreted for string comparisons as "equals",
> but
> >rather as "contains," so that "[Subject] = 'Outlook'" matches all
> items that
> >have "Outlook" or "outlook" anywhere in the Subject field. To create
> a true
> >equality filter, you must use <= and >= together, as in this example.
> but with folder restriction it;s not the case - see eg above
> Thanks
Folder Restriction