I don't understand. I have read everything from past postings but I do not understand why the bellow function isnt working.

=HYPERLINK("mailto:"&Setup!H16&"?subject="&'T1'!B2 :M2&"&body='T1'!A17:C17, "Email")

I am trying to make it so that once information is tryped into a cell that I can click a link to open a email with subject cell and email auto populates.

I may have lost my mind and I am sorry but if there are any Excel pros out there please help.

Thank you.

- Billy