+ Reply to Thread
Results 1 to 3 of 3

Convert plain text email addresses to open Outlook when clicked

  1. #1
    Registered User
    Join Date
    01-19-2010
    Location
    London, UK
    MS-Off Ver
    Excel 2010
    Posts
    18

    Convert plain text email addresses to open Outlook when clicked

    Hello, hope you can help me.
    Did this some time ago and for the life of me I cant remember how.
    Excel 2010

    I have been given a plain text list of hundreds of email addresses but need to make them active so they open Outlook when clicked.

    I know how to use autocorrect so they are active when typed in one by one but not how to convert them from a plain text list.
    Many thanks

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Convert plain text email addresses to open Outlook when clicked

    With an email address in A1, this formula in B1 creates a "mailto:" link you can click:

    =HYPERLINK("Mailto:"&A1,"Send Mail")
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    01-19-2010
    Location
    London, UK
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Convert plain text email addresses to open Outlook when clicked

    Thanks, I had tried that function already, which whilst it works needs to create another column in an already cluttered sheet.
    I found a VBA script online that will work

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1