Home All Groups Group Topic Archive Search About

Outlook E-mail Addresses in Excel

Author
6 Mar 2009 5:47 PM
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  
john.***@zyx.com).
Thank you
Carl

Author
6 Mar 2009 7:39 PM
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
> john.***@zyx.com).

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?

--
f.h.
Microsoft Outlook MVP