Results 1 to 2 of 2
  1. #1

    billwill's Avatar
    Member Since
    Feb 15, 2008
    Winston-Salem, NC
    8 GB 13" MacBook Pro, 64GB WiFi/4G iPad, 32GB iPhone 5
    Email "labels" in Excel?
    I'm using Microsoft Office for Mac 2011, filling in a large spreadsheet for a professional group I'm a member of.

    I have a column that is all email addresses. I'd like to "label" the column so when someone clicks on one of the addresses, it will automatically take them to an email screen with the name already in the "To" slot. I know there's a way to do this but for the life of me, can't find it in the Microsoft documentation or in Excel's Help. Please help! Thank you in advance.
    "Laughter is an instant vacation"
    - Milton Berle

  2. #2

    txtchr's Avatar
    Member Since
    Apr 04, 2011
    15" MBP, 2 GHz i7, 4 GB RAM
    The individual addresses can be linked two separate ways:

    1. The individual address can be entered as a valid email address. Once entered with the @ symbol, Excel will recognize this and automatically hyperlink that email address into the TO field of a message.

    2. If you'd like to mask your email addresses under the names of the individuals, you can type the person's name in the cell and press Enter to get Excel to accept the label value. Go back to the cell, right click, choose Insert Hyperlink, and in the Link To field, type: "" (obviously without the quotes and inserting the actual email address -- but you must preceed it with mailto:).

    In either case, the color of the field will change to blue to show it is hyperlinked.

    Hope that's what you're looking for.
    "The only thing that is constant is change." -- Heraclitus

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel "Document not saved" message
    By Makala in forum Switcher Hangout
    Replies: 7
    Last Post: 08-04-2014, 04:31 PM
  2. Replies: 1
    Last Post: 03-26-2014, 08:36 AM
  3. Any way to use something like "labels" in Mavericks?
    By damanieu in forum OS X - Operating System
    Replies: 2
    Last Post: 02-15-2014, 06:11 PM
  4. Excel 2011 hyperlink "cannot open the specified file"
    By caligirl in forum OS X - Apps and Games
    Replies: 0
    Last Post: 06-08-2011, 10:56 AM
  5. Uploading Photos via "Media" tab. Can you get Labels for events?
    By funkydan92 in forum OS X - Operating System
    Replies: 3
    Last Post: 11-27-2009, 03:30 AM

Posting Permissions

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