Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Email "labels" in Excel?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="txtchr" data-source="post: 1350828" data-attributes="member: 197463"><p>The individual addresses can be linked two separate ways:</p><p></p><p>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.</p><p></p><p>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 <strong>Insert Hyperlink</strong>, and in the <strong>Link To</strong> field, type: "mailto<img src="/images/smilies/angel.gif" class="smilie" loading="lazy" alt=":a" title="Angel :a" data-shortname=":a" />ddress@domain.com" (obviously without the quotes and inserting the actual email address -- but you must preceed it with mailto:).</p><p></p><p>In either case, the color of the field will change to blue to show it is hyperlinked.</p><p></p><p>Hope that's what you're looking for.</p></blockquote><p></p>
[QUOTE="txtchr, post: 1350828, member: 197463"] 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 [B]Insert Hyperlink[/B], and in the [B]Link To[/B] field, type: "mailto:address@domain.com" (obviously without the quotes and inserting the actual email address -- but you must preceed it with mailto:[I][/I]). 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. [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Email "labels" in Excel?
Top