Forum Discussion
Julius1125
Jan 23, 2024Copper Contributor
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?
- NikolinoDEGold Contributor
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.
- Julius1125Copper ContributorThank you it works