Hi I have a spreadsheet of 400 names, positions and e-mails which are constantly being updated. I can sort using the filters to get manager, technician etc. Each name has an e-mail in a separate column.
So I can then mail groups of people or all of them as needed I need to extract the e-mail addresses and get them into the format email@example.com;susanbloggs'gmail.com;firstname.lastname@example.org
i.e all separated by a semi colon.
Can anybody tell me an easy way of doing this?
Here are the steps I use when I need to create email lists from Excel:</SPAN></SPAN>
Copy your Excel list of email addresses and paste it into Word. It will paste in as a table (you don't need to copy the column header but if you do, you can just delete it later; you won’t need it)
Select All and Convert Table to Text – the result will be a straight list of email addresses with a paragraph mark at the end of each one (¶). (You won’t see the paragraph marks unless you have the option to Show Formatting Symbols turned on. You don't need to see them in order to replace them</SPAN>
Use Find and Replace to find “^p” without the quotes, and replace with “; ” without the quotes. (That says to replace all the paragraph marks,” ¶”, with a semi-colon plus a space; the extra space just helps make it more readable
Click your choice of the Find/Replace buttons. You should then end up with a block of email addresses that can be copied/pasted into your email application.</SPAN></SPAN>
You may want to clean up the results by deleting any unnecessary data (like the column header if you initially copied it or maybe extra spaces or commas at the end of the list</SPAN>
Hope this helps.</SPAN></SPAN>