Excel hyperlinks - add custom and dynamic text to email body

Is there a way to generate hyperlinks in cells F10:F500 so that each hyperlink, when clicked, will create a new email that not only contains the recipient "me@myfirm.com", and the subject "Trade Order", but also populates the body of the email with a 4x2 table and inserts the contents of the current cell into the first row, second column? see screenshot below. I assume this would be done with vba?


If table is not an option, I would be happy with just being able to embed the email body with the contents of the cell that the hyperlink is associated with. For Example, If there is a hyperlink on F2 then when it is clicked on, it will produce an email with the following string in the body {02006LZ97 corp des <go>}, the part that is bold is dynamic (it's the contents of the cell that the hyperlink is associated with).

Also, if any of this is possible, will the custom hyperlinks work when the excel file is saved as a PDF?