05-10-2010 01:38 PM
I have tried to create a Group of Insurance Agents within specific set of Zip Codes.
I have defined the zip codes within a county by Field Code/Zip Code: Operator/Starts With: Value (the Zip Code) Or .
Then I have defined the Agent by Field type/Contacts: Field Name/Title: Opperator/Equal: Value/Agent: Both And and then with Or
The resuts are all contacts within those zip codes reguardless of their Titles.
How can I limit this group to only agents within these Zip Codes?
05-11-2010 03:14 PM
I would use the advanced lookup feature so that you can repeat the lookup with the same set of criteria. The problem with groups is that unless you keep adding members to the group, they become outdated almost immediately.
There will be two sections in the lookup:
1. Zip Codes: Look up all the zip codes you want by using the “or” at the end of each line
2. Once all the zip codes are entered, you will need to surround the first and last with parantheses.
3. After the last one, you will use the “and”
4. ID/Status: Look up all the ID/Status codes that contain “agent”. That will restrict the lookup to the zip codes AND agent in the ID/Status.
Make sure you save the lookup. You will then use the lookup for the activity you have planned (eMail blast, letter merge, phone blast, Excel export, etc.)
If I have overlooked something, I'm sure one of the consultants on the board will refine the above to make more sense.
10-19-2011 06:57 AM
I was having the same problem and came across this post. I had never notced the two columns in the advanced search dialog that contained the open and the closed parentihesis. I was searching on two zip codes within one ID/Status. I added the open parenthesis before the first zip code and the closed patrenthesis after the last and it worked great.
My forum search was Advanced Lookup And Or. Hopefully this will help more people having the same problem.
Thanks again even though you solved today's problem over a year ago !