Email hyperlink that subject line will reference cell content

[JK]

We are working on a spreadsheet and we need an email hyperlink with a subject
line that will reference the content in a cell in our worksheet. For
example; in the worksheet, we have an invoice number and we want that to be
in our subject line, however the invoice number is updated frequently. How
can we have our subject line updated automatically to reflect this change?
I'm thinking this will have something to do with a macro but I'm not sure and
I'm not very familiar with them. Any help would be greatly appreciated!

 

[JK]

Okay so I found the answer to my own question so here it is in case anyone
else needs it:

HYPERLINK("mailto:[email protected]?subject=" & A1,"Mail me")