How to Hyperlink an Email Address and make it "Active" or "Live" or "Clickable"

xoTiffanie 1 Reputation point
2021-09-28T00:24:55.993+00:00

I honestly can't believe there is not a simple button for this. Or maybe there is?

I have a list of 400 people's names in column A and their email address in column B. I would like to make column B clickable, without having to go in and hit space or enter on each one. How do I accomplish this?

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,645 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,508 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,643 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor
    2021-09-28T09:09:00.16+00:00

    Hi @xoTiffanie ,
    The requirement is not very clearly, do you want the email address hyperlink automatically in cell?
    If yes, you can run this code, the sample is email in Column B and add hyperlink in Column B: 

    Sub Drawing_Hyperlink()  
  
  Dim r As Integer, hang As Integer  
    
  r = ActiveSheet.UsedRange.Rows.Count  
    
  For hang = 2 To r  
    
    Cells(hang, "B").Select  
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _  
        "mailto:" & Cells(hang, "B").Value  
    Application.ScreenUpdating = False  
     
    Next hang  
          
     
End Sub

    If my understanding is incorrect, please provide more information and I'm glad to helpyou.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments