Killer macro idea for business mailings

  • Thread starter Thread starter Robert Blackwell
  • Start date Start date
R

Robert Blackwell

One of you programmers should write a macro to validate a city from zip
code. I receive excel files from response cards and a lot of people will put
some random letters for their city instead of the actual city name, or maybe
they'll put the wrong abrieviation for their state. It would be awesome if
all the zipcodes could validate the state field and change if necessary and
the same for the city fields too.

Okay, have at it :)
 
Okay, well good idea I think anyways, but it turns out that my columns just
weren't wide enough so it didn't display more then 2 letters.
 
Back
Top