Paste friendly link into Outlook

Desperately hoping for a solution to this! 

When pasting something from the MS Teams version of Excel into Outlook, my "friendly links" stop working. That is, I have a cell that uses the formula: 

=hyperlink(link_location, [friendly_name])  

When I paste the contents into the body of an outlook email, only the "Friendly Name" text is there, and it is no longer a hyperlink. 

The hyperlink is retained if I paste from desktop version of Excel into an outlook email, but NOT if I paste from within MS Teams Excel into an outlook email. Does anyone know a workaround for this? Personally I always just open MS Teams Excel in the desktop version of Excel, but I am overseeing other users for whom that additional step is too complicated.

Thanks very much!