Let's say that you
are a direct marketer and you want to send out a mass mailing to all
addresses within a 50 mile radius of a particular ZIP Code. You have
an Access MDB or ACCDB file containing the names, addresses and email
addresses of contacts you've collected, and you now want to create a
CSV file containing only those records that are within "x" miles of
a certain ZIP Code. Simply launch ZIP Code Access, and:
1) Enter the ZIP Code you wish to search from,
2) Enter the distance in miles you wish to
search within,
3) Choose the existing Access MDB or ACCDB file on
your computer or network that contains your data,
4) Identify which table within the database
contains your data,
5) Identify the field name that corresponds
to ZIP Code field, and finally,
6) Click the "Begin search" button.
Within seconds you will have a summary
identifying how many records were found within the specified
distance from the ZIP Code you entered in step 1.
You can then save the results to a new comma
separated value (CSV) file, which will then automatically open in
Microsoft Excel for your convenience. You can also filter which
fields within the results you wish to save. For example, if your
Access database contains name, street address, city, state, ZIP
Code, phone number, and email address fields, you may choose to save
only the email addresses in your new CSV file, or any combination of
fields.
ZIP Code Access!...
There is no easier way to search and export data based upon ZIP Code
distances! |