• If you have Enterprise, you can use Data Driven Subscriptions. If not, I think you can use Jason Selburg's solution.

    http://www.sqlservercentral.com/scripts/Miscellaneous/31733/