Hi @Kolb,Laure ,
This issue isn’t related to SQL server, you added SQL server tag for this issue, but I search this from Google.
Quote this MS document Create templates for email,
>To include a hyperlink in an email template, type the URL including the http://, for example, http://contoso.com. Do not include a period or comma or a space after the URL or the link will break. Select the link text and select Make this a Hyperlink.
If it is not work. Your issue is related to Dynamics 365, Dynamics 365 is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).
I suggest you ask the experts in the Dynamics 365 forum over here:
https://community.dynamics.com/f
Best regards,
Cathy
If the response is helpful, please click "Accept Answer" and upvote it.