Expanding =HYPERLINK() functionality in include BODY

[JMay]

This is working fine:

=HYPERLINK("mailto:" & C35 & "?subject=" & $A$1,A35)

But can I ADD-ON a reference to the "?body="

where in Cell $A$2 = "This is data to pass into my email body"

Thanks,

 

[Dave Peterson]

Try:

=HYPERLINK("mailto:"&C35&"?subject="&$A$1&"&body="&$a$2,A35)

 

[JMay]

Thanks Dave; I was trying to use the "?" before the "body" - thatis ?body="
thinking it was necessary as it is in ?subject="