T
tcmetrock
Operating System: Mac OS X 10.5 (Leopard) How do you filter a mailing list by zip code?
J
John McGhie
Autofilter.
If you can't be bothered to type a detailed question, we can't be bothered
to type a detailed answer
This email is my business email -- Please do not email me about forum
matters unless you intend to pay!
If you can't be bothered to type a detailed question, we can't be bothered
to type a detailed answer
This email is my business email -- Please do not email me about forum
matters unless you intend to pay!
T
tcmetrock
Sorry. I thought this was a help forum. I have a huge state-wide mailing list on disk and I need to condense it to the addresses in my area. I am sorry I bothered you. I will seek help elsewhere. I am very new to this software and this site. I thought it was friendly here.
B
Bob Greenblatt
It is friendly here, but you need to state your problem precisely enough
so that we can help. Have you tried sorting the list? If this is not
waht you want you will need to explain in more detail what you are
trying to do.
C
CyberTaz
John's suggestion of using the AutoFilter feature is about the only
responsible reply one can offer based on the scant amount of information in
your post. There are a number of other possibilities, but those of us who
volunteer our time in the group are not inclined to type out half a dozen
procedures, most of which may very well be inappropriate to your
circumstances. We are neither clairvoyant, psychic, nor telepathic.
It isn't even certain that you're using Excel, let alone what version. That
info can make a difference in many cases. And there's no indication of what
your ultimate objective may be. The suggestion is that "mailing" is somehow
involved in which case it may even be preferable to do the filtering/sorting
in Word (or whatever program you intend to use for generating the
labels/envelopes/form letters you intend to create from the data).
Quite frankly, you'll find that this is one of the friendliest, most helpful
& most accommodating resources available. I believe you may have taken
John's good-natured chastisement a bit too seriously... Note the smiley [
] at the end of his reply.
Regards |:>)
Bob Jones
[MVP] Office:Mac
responsible reply one can offer based on the scant amount of information in
your post. There are a number of other possibilities, but those of us who
volunteer our time in the group are not inclined to type out half a dozen
procedures, most of which may very well be inappropriate to your
circumstances. We are neither clairvoyant, psychic, nor telepathic.
It isn't even certain that you're using Excel, let alone what version. That
info can make a difference in many cases. And there's no indication of what
your ultimate objective may be. The suggestion is that "mailing" is somehow
involved in which case it may even be preferable to do the filtering/sorting
in Word (or whatever program you intend to use for generating the
labels/envelopes/form letters you intend to create from the data).
Quite frankly, you'll find that this is one of the friendliest, most helpful
& most accommodating resources available. I believe you may have taken
John's good-natured chastisement a bit too seriously... Note the smiley [
] at the end of his reply.Regards |:>)
Bob Jones
[MVP] Office:Mac