Place code in the Application_Startup event in the ThisOutlookSession
class module in the Outlook VBA project and call your macro from
there. It will run automatically after Outlook starts up if macros are
enabled.
Use the StartUp Event of the Application. However, you must have your security settings set to LOW for it to happen without acknowledging it. This may not be a good idea.