Thread: Email "labels" in Excel?
01-05-2012, 12:36 PM #1
Email "labels" in Excel?
- Member Since
- Feb 15, 2008
- Winston-Salem, NC
- 8 GB 13" MacBook Pro, 64GB WiFi/4G iPad, 32GB iPhone 5
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
01-05-2012, 09:32 PM #2
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: "mailto:email@example.com" (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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Makala in forum Switcher HangoutReplies: 7Last Post: 08-04-2014, 04:31 PM
By sothavok in forum OS X - Operating SystemReplies: 1Last Post: 03-26-2014, 08:36 AM
By damanieu in forum OS X - Operating SystemReplies: 2Last Post: 02-15-2014, 06:11 PM
By caligirl in forum OS X - Apps and GamesReplies: 0Last Post: 06-08-2011, 10:56 AM
By funkydan92 in forum OS X - Operating SystemReplies: 3Last Post: 11-27-2009, 03:30 AM