Microsoft Outlook email - Restrict Method - Find only blank fields

Outlook Banter (http://www.outlookbanter.com/)

- Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)

- - Restrict Method - Find only blank fields - VBA (http://www.outlookbanter.com/outlook-vba/49690-restrict-method-find-only-blank.html)

Irene

June 4th 07 08:25 PM

Restrict Method - Find only blank fields - VBA

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

Eric Legault [MVP - Outlook]

June 5th 07 05:25 PM

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

All times are GMT +1. The time now is 01:12 PM.