Home

Hyperlink table reference for email address showing wrong address

%3CLINGO-SUB%20id%3D%22lingo-sub-352273%22%20slang%3D%22en-US%22%3EHyperlink%20table%20reference%20for%20email%20address%20showing%20wrong%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352273%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI%20have%20a%20table%20(CCAL_Membership)%20on%20one%20tab.%20In%20another%20tab%20(Print%20Copy)%20I%20have%20a%20column%20that%20references%20the%20email%20column%20of%20the%20CCAL_Membership%20table.%20In%20the%20Print%20Copy%20table%20it%20is%20showing%20the%20right%20email%20address%20as%20pulled%20from%20the%20CCAL_Membership%20table.%20The%20Hyperlink%2C%20however%2C%20is%20returning%20an%20entirely%20different%20email%20address.%20I%20can't%20figure%20out%20why%20or%20how%20to%20fix%20it.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20please%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPhoto%20and%20copy%20of%20the%20full%20spreadsheet%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBarbara%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-352273%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352336%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlink%20table%20reference%20for%20email%20address%20showing%20wrong%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352336%22%20slang%3D%22en-US%22%3EYou%20can%20use%3A%3CBR%20%2F%3E%3DHYPERLINK(%22mailto%3A%22%26amp%3BEmailAddress%2CFriendlyName)%3C%2FLINGO-BODY%3E
BTeusink
Occasional Visitor

Hi!

I have a table (CCAL_Membership) on one tab. In another tab (Print Copy) I have a column that references the email column of the CCAL_Membership table. In the Print Copy table it is showing the right email address as pulled from the CCAL_Membership table. The Hyperlink, however, is returning an entirely different email address. I can't figure out why or how to fix it.  

 

Help please??

 

Photo and copy of the full spreadsheet attached.

 

Thank you for any help!

 

Barbara

 

1 Reply
You can use:
=HYPERLINK("mailto:"&EmailAddress,FriendlyName)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies