VBA to Pull Name, Phone Number and Email from an address

Hey Everyone,

I have a list of over 10000 lines of addresses and I want to have a macro or API to look up all those addresses and populate the name (business or residential), phone number and email.

I while this is not the site i want to use, I feel like this is the closest i can find to do what i need to do... https://www.youtube.com/watch?v=7sZRcaaAVbg.

I don't care if its yelp, yellow pages, white pages, etc... just want something that works.

Thanks!

bump bump bump bump

do you have a sample file>