It takes a more complex search string using >= instead of = and adding a <
expression. So what you're doing is asking for names >= "Smith" and <
"Smith{"
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm
Quote:
> I am using the Restriction Method to obtain all the Contacts with the same
> Last name and it is working perfect. The issue is that I need to also
have
> all the contacts that the last name start with the string. For example
> retrieve all the contacts that have the last name Smith or Smithxxxxx.
> The code that I am using is:
> Set MyContas = MyItems.Restrict("[Last Name] ="&LastN)
> What I should use if I want to retrieve all the contacts with the same
last
> name and lives in NJ?
> Thanks for your help.
> Pat Hirsch
Restriction Method