Is it possible to run a vba script/macro that will look at the current selected email and copy certain text within the subject to the clipboard.

For example, I have emails come in with the subject line:

QUERY ID #id1234567v1 is ready to be assigned to a member

This subject is always the same (apart from the id number) and the length will never change.

I would like to select an email and run the a vba/macro that will copy the id1234567v1 to the clipboard

Is this possible?