Excel 365 email hyperlink, subject, cell content and attachment

Hi, I want to add an email hyperlink with a subject line (excel 365) and would like to add the content of a cell (B6) at the end of the subject line and automatically get the excel sheet to attach to the email when clicking on the hyperlink text.

The first part I know how to do (up to naming and adding the email hyperlink and subject line, it's the second part (adding content of cell B6 at end of subject line and attach excel doc ready to send when clicking the hyperlink) that I am struggling with, I'm not even sure I can add the content of a cell at the end of a pre-determined subject line text.

Thank you

Arno