Unfortunately, I am running on Standard Edition so Data Driven Subscription is not an option anymore.

Have you try using SSIS as an alternative ? I am just unsure the process on how to do it in SSIS.