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