extracting the email adress of a contact

Joachim Mund

Hi,

I'm not able to use the email adress of a contact in another cell.

I need this for building a specific link in another cell. e.g. https://blabla.com/#browse/profile/john.doe@gmail.com

="https://blabla.com/#browse/profile/" + contact2 will not work :-(, it returns the name of the contact.

Any idea how to get this working?

Alejandra

Hi Joachim,

When you create a reference an individual cell —the surface value is returned. If you're goal is to return the email address, then the email address must be the surface value.

Depending on the number or email addresses you're working with, you may want to consider either editing the Contact List properties so that it only contains only email addresses in the preferred values text box —or— you could create a new column (with only email addresses in the preferred values text box), reference the cells in this column in your formula, and hide it if needed.