how do I make the macro run every time I load that site so I can login without having to do anything?
Running a macro on loading a specific website can not be done. But you could store a link to this macro as bookmark. Then you can run the macro without opening UI Vision! See here: