HYPERLINK trigger macro

[brumby]

Hiya,

I have a Hyperlink function that opens Outlook to a specific email address relevant for that supplier.

Is it possible to also run a macro, that copies and Pastes the text from cell H7 into the body of the email the hyperlink created?

Many Thanks