I am working with a non profit organization and have no budget to support this task although I might be willing to spend something personally if necessary.
I have a file with about 2000 records/rows including street addresses for each record. I have an event that will be at a known street address. I want to know which of the street addresses, from the 2000, will be within one hour driving or 60 miles of the event address in order to know to whom I should send an invitation. If I had email addresses it is obvious that I could send to all and let the reader make their own decision. But I only have street addresses for an old fashioned USPS mailing, not emails, and do not want to pay the money for physical mail to those who are too far away to be very unlikely to attend.
I would settle for a calculation using just the zip code as a close approximation if necessary.
This will probably be a need that reoccurs from time to time in the future so I would like to find a way of automating the task.
I understand the math/logic used in spreadsheets but have very limited understanding of VBA or Google Distance API calls etc.
Any help is appreciated.
Richard
Greenville SC USA
I have a file with about 2000 records/rows including street addresses for each record. I have an event that will be at a known street address. I want to know which of the street addresses, from the 2000, will be within one hour driving or 60 miles of the event address in order to know to whom I should send an invitation. If I had email addresses it is obvious that I could send to all and let the reader make their own decision. But I only have street addresses for an old fashioned USPS mailing, not emails, and do not want to pay the money for physical mail to those who are too far away to be very unlikely to attend.
I would settle for a calculation using just the zip code as a close approximation if necessary.
This will probably be a need that reoccurs from time to time in the future so I would like to find a way of automating the task.
I understand the math/logic used in spreadsheets but have very limited understanding of VBA or Google Distance API calls etc.
Any help is appreciated.
Richard
Greenville SC USA
