Using Hyperlinks to send email

[LostCause]

Firstly, thanks for reading.

I want a Hyperlink which when clicked creates a new email in Outlook and fills in some of the fields.

I have tried using:




My problem is there is no space to put the body of the email. Does anyone know of a way of doing this?

Thanks.

 

[LostCause]

Anyone?

 

[Oaktree]

=HYPERLINK("mailto:address@somewhere.com&subject=this is my subject&body=body of the e-mail goes here","what to display in the cell goes here")

 

[LostCause]

If this works I'm going to kiss you