I think I've solved this one. It's always the way... as soon as you post asking for help, the answer appears as if by magic.

It seems that using the HYPERLINK/Mailto function works perfectly.

Example2.xlsx