Bulk Updating City Based on Postal Code

Hi there,

We've got a number of addresses on constituent records where the postal code field is populated but the city is not (mostly due to our recent implementation of True Tickets, which only requires users to enter a zip code when accepting a shared ticket if they are creating a new account). If we were hand-keying these addresses in on the front-end, the city would of course populate when the zip was entered. Does anyone have a procedure for replicating this functionality on the back end in bulk? I'd love to schedule a proc to run on a daily/weekly basis to update these addresses if possible.

Thanks!

Lauren