Paste friendly link into Outlook

%3CLINGO-SUB%20id%3D%22lingo-sub-2121847%22%20slang%3D%22en-US%22%3EPaste%20friendly%20link%20into%20Outlook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121847%22%20slang%3D%22en-US%22%3E%3CP%3EDesperately%20hoping%20for%20a%20solution%20to%20this!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20pasting%20something%20from%20the%20MS%20Teams%20version%20of%20Excel%20into%20Outlook%2C%20my%20%22friendly%20links%22%20stop%20working.%20That%20is%2C%20I%20have%20a%20cell%20that%20uses%20the%20formula%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3Dhyperlink(link_location%2C%20%5Bfriendly_name%5D)%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20paste%20the%20contents%20into%20the%20body%20of%20an%20outlook%20email%2C%20only%20the%20%22Friendly%20Name%22%20text%20is%20there%2C%20and%20it%20is%20no%20longer%20a%20hyperlink.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20hyperlink%20is%20retained%20if%20I%20paste%20from%20desktop%20version%20of%20Excel%20into%20an%20outlook%20email%2C%20but%20NOT%20if%20I%20paste%20from%20within%20MS%20Teams%20Excel%20into%20an%20outlook%20email.%20Does%20anyone%20know%20a%20workaround%20for%20this%3F%20Personally%20I%20always%20just%20open%20MS%20Teams%20Excel%20in%20the%20desktop%20version%20of%20Excel%2C%20but%20I%20am%20overseeing%20other%20users%20for%20whom%20that%20additional%20step%20is%20too%20complicated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20very%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2121847%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

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.