Extracting Email Addresses

S

Scott

I have an Excel worksheet that has a column of email
addresses. I want to compose an email to all of the
addresses. Outlook requires that email addresses be
separated by commas. Is there an easy way to extract all
of the email addresses from the worksheet and arrange into
a format of [email protected], [email protected],
[email protected], e.t.c.

Thanks In Advance

Scott
 
B

Bernard Liengme

Scott,
It is not elegant but it should work.
1) Select the column of e-mail addresses and click Copy
2) Move to a blank worksheet on a new workbook
3)Use Edit|PasteSpecial, Transpose
Now you ahve the addresses in a row
4)Use SaveAs and stipulate Comma Delimitied (CSV)
5) Open the CSV file in Notepad, use Copy and Paste to an email client
program
Bernard
 
S

Scott

Great idea! Why didnt I think of that? Is there a way to
automate the process and activate it with a click?
 
Top