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

xoTiffanie 1 Reputation point

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.
11,321 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,698 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,687 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 23,586 Reputation points Microsoft Vendor

    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 No comments