One new line has provided me exclusivity with counties in SoCal (San Diego County, Imperial, Los Angeles, Orange County, Riverside, San Bernadino, Santa Barbara, and Ventura), I have a list of all the zip codes associated with each of the counties however there are too many zip codes to create a single report giving me a list of all accounts for the given region (Zoho limits 25).  I need to be able to pull only the contacts in this region from my full db to create targeted communications.

Is there a way to auto detect the US county from the zip code? I have always ensured all my accounts have a zip code (single line text field). If I had an auto populating US county I can create reports based on the counties selected and therefore ensure I only send communications to people in the counties of Southern California.

Many thanks in advance!

Carl