Mailto in Excel ??
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 |
All times are GMT +1. The time now is 12:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com