I've got a column of email addresses in Excel (exported from Outlook
Express) and for some reason only one is properly coded as a 'mailto'
hyperlink.

Is there a way to select that column and convert all the email addresses to
hyperlink (mailto) addresses? I tried but they ended up as mailto: [blank].
I of course want them to be coded as mailto: [the listed email address
already in the cell] Might I have to run a macro and enter each one in
individually? (I hope not.)

Any help would be greatly appreciated.

Bob

http://www.mvps.org/dmcritchie/excel...MakeEmailLinks

--
Regards,

Peo Sjoblom

(No private emails please)


"InOverMyHead" wrote in message
...
I've got a column of email addresses in Excel (exported from Outlook
Express) and for some reason only one is properly coded as a 'mailto'
hyperlink.

Is there a way to select that column and convert all the email addresses
to
hyperlink (mailto) addresses? I tried but they ended up as mailto:
[blank].
I of course want them to be coded as mailto: [the listed email address
already in the cell] Might I have to run a macro and enter each one in
individually? (I hope not.)

Any help would be greatly appreciated.

Bob