I have a bunch of contacts with two addresses. Each of their addresses is a different type (home, main, billing, etc). For these contacts, the billing address is primary.
I'd like to delete the billing addresses from the system and have the remaining address for each contact be left as the primary address.
I know how to do this one-by-one, but with more than 1,000 records to do I'd like a way to automate this. I have ID numbers for every contact that needs this change. Any ideas?