Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

This function does not work, why?

Copper Contributor

=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?

2 Replies

@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.

Thank you it works