Add the emails as hyperlinks - get it recognized by contact list

Viktor Palles

Hi All,

is this function supported: =Alias@row&"@email.com" - in the 'Alias' column I have logins & I would like to add to this aliases in another column also the domain: "@email.com" so they get recognized by the contact list.

Thanks - Viktor

Robert Charles

This may take a few iterations: This is not the full answer because breaks easy.

Column formula: =IF(NOT(ISBLANK(Alias@row)), Alias@row+"@"+Domain@row)

Below is Row 3 being assigned a contact. The dropdown includes all calculated contacts and the ones in the contact list.

And the contact list:

Robert Charles

This may take a few iterations: This is not the full answer because breaks easy.

Column formula: =IF(NOT(ISBLANK(Alias@row)), Alias@row+"@"+Domain@row)

Below is Row 3 being assigned a contact. The dropdown includes all calculated contacts and the ones in the contact list.

And the contact list:

Viktor Palles

Thanks a lot, Robert - It helps a lot