Outlook E-mail Addresses in Excel

C

Carl

I inherited an Excel file with 985 email address in them. The problem is
that they exist in Excel as hyperlinks, which when clicked on launch a new
Outlook email.
I need to send all these email address to an outside vendor. How can I
convert all these hyperlinks to a column of email address (such as
(e-mail address removed)).
Thank you
Carl
 
F

F.H. Muffman

I inherited an Excel file with 985 email address in them. The problem is
that they exist in Excel as hyperlinks, which when clicked on launch a new
Outlook email.
I need to send all these email address to an outside vendor. How can
I convert all these hyperlinks to a column of email address (such as
(e-mail address removed)).
Click to expand...

Probably better to ask in Excel, since they'll know more about the data manipulation
than we would, but, the hyperlinks, are they just user@domain or are they
friendly names?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Contains E-mail Addresses 5
importing e mail addresses from excel 1
Open specific hyperlink (accept) automatically in email with outlook 0
Hyperlinks with "friendly name" possible? 3
outlook email addresses extraction 1
TO and CC email addresses hidden when forwarding an email [Outlook2007] 3
Incoming e-mail doesn't treat hyperlinks correctly 1
Outlook 2007 adding single quotes around e-mail addresses 6

Top