Hello all,
I am using the following formula:
=HYPERLINK("MAILTO:" & B3 & "?subject=" & A1 & "&body="& A2,"Send Mail")

but I need the body to encompass more than one cell, to be specific:

=HYPERLINK("MAILTO:" & B3 & "?subject=" & A1 & "&body="& A2:B8,"Send Mail")

but when I do that it kills the formula. Anyone know the correct way to get this done?

Thanks in advance!