Checking for missing properties in a Restrict method filter string

[Roger Henn via OfficeKB.com]

I'm trying to use the Restrict method to filter an Items collection based on the NoAging property, but some of the MailItems don't have a NoAging property. I want to get any item with NoAging of False, or without the property at all.

I've tried "Not([NoAging] = True)", but it looks like the missing property always gives a False (or Null) result, even if you precede it with a Not. There doesn't seem to be any way to test for Null in a filter string expression ("IsNull([NoAging])" results in an invalid condition error).

Anyone got any ideas how to??

 

[Jim Vierra]

This works for the Inbox with no exceptions

Dim f As MAPIFolder
Dim n As NameSpace
Set n = Application.GetNamespace("mapi")
Set f = n.GetDefaultFolder(olFolderInbox)
f.Items.Restrict ("[NoAging] = False")

 

[Michael Bauer]

Hi Roger,

a MailItem´s MessageClass is "IPM.Note". I suppose the items with no
NoAging property have a different MessageClass property. If so then you
can restrict for (MessageClass="IPM.Note" and NoAging=False).

Or, much better, restrict for MessageClass <> the class with no NoAging.

--
Viele Grüße
Michael Bauer

I'm trying to use the Restrict method to filter an Items collection

based on the NoAging property, but some of the MailItems don't have a
NoAging property. I want to get any item with NoAging of False, or
without the property at all.

I've tried "Not([NoAging] = True)", but it looks like the missing

property always gives a False (or Null) result, even if you precede it
with a Not. There doesn't seem to be any way to test for Null in a
filter string expression ("IsNull([NoAging])" results in an invalid
condition error).