Excel – Column of email addresses. How do I make each cell hyperlink to that email?

November 2 2010 by Admin in Microsoft Excel |2 Comments

I hаνе аn Excel spreadsheet, Column M іѕ populated wіth email addresses. I want tο рlοt thіѕ column ѕο thаt whеn I click οn thе email addresses іt opens аn email addressed tο thаt email address. Hοw саn I dο thіѕ? I’m hoping tο dο thіѕ using formatting οr style οr something. I really don’t want tο change each cell individually.

I’m using Microsoft Office Professional Edition 2003.

2 Comments

  • kokevi_t says:
    November 2, 2010 at 10:39 pm

    I’m not sure if 2003 automatically assigns hyperlinks to items it recognises as email addresses. You could try F2 and then Enter to see what it does. Otherwise you can run some VBA code to place the hyperlink into each cell:

    Sub Email()

    For i = 0 To 10

    X = Array(“M1″).Offset(i, 0)
    Y = “mailto:” & X

    Array(“m1″).Offset(i, 0).Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
    Y, TextToDisplay:=X

    Next i

    End Sub

    The code won’t work with numbers or empty cells, so you could refine it a bit.

  • Jeremy says:
    November 2, 2010 at 11:07 pm

    That’s amusing– when I type an email address in a cell in Excel, I can simply click on it and it does exactly as you’re asking here– opens a new outlook message with the To: address already populated. I’m using Excel 2003. I wonder if the cells in your Col M are formatted differently (I believe there’s some setting where the hyperlink isn’t active) or if you have leading/trailing spaces or some kind of character stuck in there?
    Try typing an email address somewhere else on the sheet (or a new workbook entirely) and see if it does the same thing, maybe?

« »