View Single Post
Old 07-01-2009, 03:21 PM   #2 (permalink)
tosh9i
TSF Enthusiast
 
Join Date: Aug 2006
Posts: 3,836
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.
tosh9i is offline   Reply With Quote