I'm trying to send e-mails with a pre-set subject and a pre-set body. I'm using the following code
=HYPERLINK("mailto:email@mail.com?subject=Test subject&body=Test body","Send email")
It works well but I would like to send a very long body. Unfortunately, seems like there is a character limit.
I need to send the emails from an email client, not from Gmail