Forum Discussion

BTeusink's avatar
BTeusink
Copper Contributor
Feb 17, 2019

Hyperlink table reference for email address showing wrong address

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

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    You can use:
    =HYPERLINK("mailto:"&EmailAddress,FriendlyName)