Community
Showing results for 
Search instead for 
Do you mean 
Reply

Advanced Lookup Based On A List of Zip Codes

Bronze Contributor
Posts: 1,449
Country: USA

Advanced Lookup Based On A List of Zip Codes

I'm creating a list of contacts that are in my db and in the MSA of a certain city.

 

The list includes 57 Zip Codes.

 

I would hate to build an adanced lookup and manually enter the 57 zip codes. 

 

Is there a faster way to enther that many options in an advanced lookup? 

 

WHILE I'M AT IT what about a way to make the bollean option become "OR" instead of "AND"?

 

Many thanks for your help and advice.

John Purdy
ACT! Premium V. 18
HP ENVY 17m, 16GB, & Office 365, 32bit, 1TB HDD.
Platinum Elite Contributor
Posts: 6,757
Country: USA

Re: Advanced Lookup Based On A List of Zip Codes

Click on the AND to change it to OR.

You may not need to add all 57 zipcodes. The first four numbers designates the region, state and city, the fifth number is a substation with in the city.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Silver Super Contributor
Posts: 2,329
Country: USA

Re: Advanced Lookup Based On A List of Zip Codes

There is a SnapInTool call Proximity for Act! that will show you all of the contacts within a specified distance from a zip code.  That would probably work for them.


Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!