10-29-2011 12:15 PM
We are running Contact queries based on zip code proximity
E.g. if we run a Google map search for all zip codes within 10 miles of 77057, then we get, say, 200 zips codes. We then want to run a query of all contacts w/in those zip codes to get a call list. Unfortunately we have to enter all 200 zips since they are not necessarily contiguous. We have tried shortening the query by doing things like “ >= and <= “ etc. but it’s still a huge task entering that query to the ACT query box. We’ve tried to change a previous queries in excel and then rename to a .QRY file but it does work. Anybody have any ideas or solutions? Thanks
10-31-2011 02:42 PM
The only way would be to get someone to write you an application to paste in your query as there is no facility as far as I know to put in a query externally.
I have done something similar for a client by taking a list and scheduling a follow up call for a weeks time in groups of 5 to each user for 150 contacts and then completing the mail merge.
Let me know offline if you wish to pursue
10-31-2011 03:19 PM
In ACT! the zip code field is alpha-numeric so a much simpler query which can be done from the zipcode field is starts with. The first three numbers in the zip code are the regional designation. The last two are local post offices.
11-01-2011 11:45 AM
I was actually hoping for a way to develop/build a query in another application (like excel or access) that can be saved as a ACT query and then run as normal saved "Advanced"query. The way ACT forces you to build the query is painful for large queries.
Thanks for the response.