This function does not work, why?

Julius1125 

It seems like the HYPERLINK function is not behaving as expected, and it's displaying the formula instead of creating a clickable hyperlink.

To resolve this issue, you can try the following formula:

English: =HYPERLINK(CONCATENATE("mailto:", I28, "?subject=Hier E-mail senden &body=Guten Tag,%0A%0Ae-Mail aus uns Excel senden Mitarbeiter.%0A%0A", C28, ", ", D28, ", ", E28, "Senden"), "Senden")

German: =HYPERLINK(VERKETTEN("mailto:"; I28; "?subject=Hier E-mail senden &body=Guten Tag,%0A%0Ae-Mail aus uns Excel senden Mitarbeiter.%0A%0A"; C28; ", "; D28; ", "; E28; "Senden"); "Senden")

File inserted as an example.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.