Paste friendly link into Outlook

Copper Contributor

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!

1 Reply
I'm going to move this post to the Excel discussion forum, where I think there are more Excel experts who can help.