|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: blank, fields, method, restrict, vba |
|
|
Thread Tools | Display Modes |
|
#1
June 4th 07, 08:25 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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 
|
| Ads |
|
#2
June 5th 07, 05:25 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook find Method | Meex | Outlook and VBA | 4 | May 4th 07 08:25 AM |
| Using Restrict method to select emails | Jerry West | Outlook and VBA | 16 | April 26th 07 06:48 PM |
| Find Method wild card search? | patrick.mcdonald@gmail.com | Outlook and VBA | 5 | May 3rd 06 03:26 PM |
| Restrict method problem | Mike Epp | Outlook and VBA | 2 | April 7th 06 08:03 PM |
| Restrict Method DNW | emanson | Outlook and VBA | 14 | March 28th 06 06:47 AM |
Linear Mode
