New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus • Advice and insight from world-class Apple enthusiasts • Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Email "labels" in Excel?


Post Reply New Thread Subscribe

 
Thread Tools
billwill

 
billwill's Avatar
 
Member Since: Feb 15, 2008
Location: Winston-Salem, NC
Posts: 394
billwill is on a distinguished road
Mac Specs: 8 GB 13" MacBook Pro, 64GB WiFi/4G iPad, 32GB iPhone 5

billwill is offline
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
QUOTE Thanks
txtchr

 
txtchr's Avatar
 
Member Since: Apr 04, 2011
Location: Texas
Posts: 72
txtchr has a spectacular aura about
Mac Specs: 15" MBP, 2 GHz i7, 4 GB RAM

txtchr is offline
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:address@domain.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
QUOTE Thanks

Post Reply New Thread Subscribe


« QuarkXpress Error Loading "QuarkXpress quit unexpectedly" | Mac Mail 5.1 and iCloud Question »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Mac Mail can send to any email except one (but can from website) kerred OS X - Apps and Games 0 08-31-2009 02:57 PM
email to excel automation software jonn OS X - Apps and Games 1 08-05-2009 05:55 PM
Mac mail cannot read email from outlook 2007 gizzzo OS X - Apps and Games 0 04-30-2009 01:47 AM
some email sent using Entourage arrives in other peoples Junk Mail. seinmind OS X - Apps and Games 1 02-22-2008 04:03 PM

All times are GMT -4. The time now is 02:06 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?