how do I search for a range of zipcodes?

R

rsoderberg@CTI

I want to search the Contacts database for all contacts within a zipcode
range, i.e. for northern New Jersey where zipcodes start with 074 to 079.
Obviously the use of wildcards would be helpful but Outlook doesn't seem to
allow them?
 
V

Vince Averello [MVP-Outlook]

In OL2003 you can use the Query Builder in Advanced Find to look for zip
codes that contain 074&, 075&, 076&, 077&, 078& or 079&

The & character is an SQL wildcard.

BTW, I consider where I live 'northern NJ' and my zip is 07002, although I'm
not as far north as my parents whose zip code fits your criteria.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Matching Zipcode Range for Address 3
Zipcode<-->Country flip 9
Normalization Question 5
Mail Merge and zipcodes.. 1
Template or Tutorial for Search Result Page? 0
How do I set focus (and select text) on a text box on a modeless userform? 0
How do I change my zipcode in AutoComplete for forms? 1
Finding the height of a row in a word table from Excel 0

Top