Word/Excel 2007 and emails

jsphillips93 · 07-01-2009, 12:45 PM

I work at a marketing firm and I am trying to go into school websites and get teacher emails from them to add to our master email list. My problem though lies in that many of the teacher lists don't actually have the emails listed but rather they are hyperlinked. How do I extract the emails from there?

For example:

http://www.pflugervilleisd.net/KLMS/staff.cfm

**tosh9i** · 07-01-2009, 03:21 PM

if you use Firefox, you can add the extension: Copy Link URL
https://addons.mozilla.org/en-US/firefox/addon/10552

After that go to that school's webpage > highlight all the names (you have to highlight the entire table) > right click on it > Copy Selected Links > then paste it in Excel > sort it, to separate the links from the email addresses > copy the email addresses > paste it in Word > there should be a small clipboard icon that appears in the bottom right of the table, click on that, then click on Keep text only > from there, go to Edit > Replace > and replace mailto: with nothing (afterall, we want to get rid of it) > Replace All > after that, go back to Replace > click on More > click on Special > Paragraph Mark > then in Replace with, type in a comma "," (since commas are used to separate email addresses).

jsphillips93 · 07-02-2009, 09:15 AM

thanks tosh9i. worked like a charm and almost have the full list done. appreciate it.

07-01-2009, 12:45 PM	#1 (permalink)
jsphillips93 Registered User Join Date: Jul 2009 Posts: 2 OS: Mac OS 10.5	Word/Excel 2007 and emails I work at a marketing firm and I am trying to go into school websites and get teacher emails from them to add to our master email list. My problem though lies in that many of the teacher lists don't actually have the emails listed but rather they are hyperlinked. How do I extract the emails from there? For example: http://www.pflugervilleisd.net/KLMS/staff.cfm

07-01-2009, 03:21 PM	#2 (permalink)
tosh9i TSF Enthusiast Join Date: Aug 2006 Posts: 3,811 OS: Windows XP	Re: Word/Excel 2007 and emails if you use Firefox, you can add the extension: Copy Link URL https://addons.mozilla.org/en-US/firefox/addon/10552 After that go to that school's webpage > highlight all the names (you have to highlight the entire table) > right click on it > Copy Selected Links > then paste it in Excel > sort it, to separate the links from the email addresses > copy the email addresses > paste it in Word > there should be a small clipboard icon that appears in the bottom right of the table, click on that, then click on Keep text only > from there, go to Edit > Replace > and replace mailto: with nothing (afterall, we want to get rid of it) > Replace All > after that, go back to Replace > click on More > click on Special > Paragraph Mark > then in Replace with, type in a comma "," (since commas are used to separate email addresses). __________________ Tosh Last edited by tosh9i; 07-01-2009 at 03:26 PM.

07-02-2009, 09:15 AM	#3 (permalink)
jsphillips93 Registered User Join Date: Jul 2009 Posts: 2 OS: Mac OS 10.5	Re: Word/Excel 2007 and emails thanks tosh9i. worked like a charm and almost have the full list done. appreciate it.