View Single Post
  #2  
Old June 5th 07, 05:25 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Restrict Method - Find only blank fields - VBA

Use double apostrophes:

Items.Restrict("[Subject] = ''")

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Irene" wrote:

Is there anyway to search only for blank fields using restrict method in VBA
Outlook.
Ex: Find all MailingAddressCountry field which are blank -

itms.Restrict ([MailingAddressCountry] = empty/blank)

Thanks

Ads