Ken-

Thanks for the reply.

Why don't Jet queries support IS NULL or ''?

Thanks,

Craig

"Ken Slovak - [MVP - Outlook]" wrote:

You can use a DASL query for that using the undocumented "@SQL=" prefix.
Using that syntax your query for only items with an Email1Address would look
like this in VB.NET:

Dim sFilter As String = "@SQL=NOT(urn:schemas:contacts:email1 IS NULL)"

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Craig Buchanan" wrote in message
...
I am trying to get a list of contacts (using the Restict() method) in a
Outlook 2003 Contact folder that do NOT have an Email1Address assigned.

These (Jet?) queries do NOT eliminate contacts without an Email1Address:

[Email1Address] ''
NOT([Email1Address] = '')
NOT([Email1Address] IS NULL) 'plus lower-case variations
"[Email1Address]" & Chr(34) & Chr(34)

Email1Address that are missing are considered Nothing in the Immediate
window, btw.

I'm using .Net framework 2.0. I am testing in Offline mode, if that makes
a difference.

Can someone shed some light on this for me?

Thanks,

Craig Buchanan