I'm mining email addresses from Public School online data source. I have imported list into excel that contains a school record that includes a unique web page link, that on linked page, contains information for single contact, including that contact's email address .
Other posts that I've seen here, deal with extracting multiple email addresses from single web page. In this case, I have links to a unique pages that list the information that I'm trying to extract for one contact record. I have tried recording a macro that clicks the link, but I can't get the macro to go to the Internet Explorer page/ Identify Email Address/ Select,Highlight Email Address / Copy/ Go back to Excell and paste in specific cell.
Any help would be greatly appreciated. I'm a beginner .
Mar
Other posts that I've seen here, deal with extracting multiple email addresses from single web page. In this case, I have links to a unique pages that list the information that I'm trying to extract for one contact record. I have tried recording a macro that clicks the link, but I can't get the macro to go to the Internet Explorer page/ Identify Email Address/ Select,Highlight Email Address / Copy/ Go back to Excell and paste in specific cell.
Any help would be greatly appreciated. I'm a beginner .
Mar
Last edited:
