Forum Discussion

Julius1125's avatar
Julius1125
Copper Contributor
Jan 23, 2024

This function does not work, why?

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

 

My function does not work i try to send mails directly from Excel 2016 but as soon as i ad e28 the formular crashes. Is there a possibility to send mid sized mails directly from Excel?

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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.

Resources