View Single Post
  #1  
Old December 16th 08, 04:11 AM posted to microsoft.public.outlook.program_addins
Craig Buchanan[_2_]
external usenet poster
 
Posts: 12
Default Restrict() method and Null values

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


Ads