I don't know SQL - what do you suggest?

Thanks

You can use a CSV file also.
Also with there be only one email address associated with each zipcode?

No probably going to divide the city into 4 quadrants and have about 50 zips for each quadrant. So when the prospective client enters an and zip code it will go to the correct email in the quadrant. And can it send all emails to master email for accounting purposes?

Thanks

Byron

I have a simple script working. I think it will give you the needed info and you can build on it. I used an email template from RED for the confirmation page. I used plain text for the emails that get sent to the person assigned to the zip code. The code allows multiple emails for the same zip code. This way if somebody needs to cover for another person. There's also a master email as a BCC.
I've attached the two files i used. My test form made in FB had only an input for a name and a zip code.
I used the Redirect to another ulr option in the form Confirm setting tab. I entered the location of the email_by_zip_processor.php file as an absolute url https://.....
Place the csv in the same location as the email_by_zip_processor.php. The code is setup to have them in the myformname_exported folder. I always export my forms and the remove the _exported off the end. You can do what ever you want, It's only important to know locations.
Start with a simple form and test. We can build on it once you know you have it working.
The email_by_zip_processor.php is commented where you need to enter your input names and email addresses for the host. You shouldn't need to alter anything below line 35 if your inputs in your test form are zipcode and name.

Thanks!!!!

Playing with this -

Byron