To run this macro automatically you can consider the following factors:
Create a rule in Outlook to run the macro when a new email arrives matching your criteria (sender, subject).
Ensure the macro is enabled in Outlook's macro security settings.
Test the rule by sending a test email.