Help with VBA to populate outlook email body requested.

Good Afternoon,

THe below code is something I am trying to modify. Currently, it attaches info to an email, but I need to modify so that the body is populated with info from a specific worksheet, which will always be the last row. Something such as

Body:
Name: Cell A
Phone: Cell B
Email: Cell C

and so on.

I am having trouble getting it to work, no matter what i have tried. Any help would be appreciated. (My changes are listed in parenthesis within the code)

HTML Code: