Yes, it is possible to link the contents of a text box in Excel to data in a cell.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

In the "Address" text box within the Insert Hyperlink dialog, type "mailto:" (without quotation marks) followed by the email address you want to link the first hyperlink to.