View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheikh Saadi
 
Posts: n/a
Default How to convert Email into Mailto Email Addresses

Hi All,

I am facing a problem. I have a list of around 700 email addresses, in which
some are hyperlinked (mailto) and some are not. Now I wanted to know that is
there any function or any way to convert all of them into Mailto Hyperlinks
that when someone clicks on them links are opened into Outlook or any email
application.
--
Sheikh Saadi