Email based on ssrs data set email

Here is my situation

I have an report that includes support person email among other items.  (There are 6 unique emails)

Here is some sample data

Recordid   customerid  orderdate        orderamount   supportpersonEmail
1                 1234              03/31/2017     100                    jdoe@email.com
2                 5678              03/29/2017     150                    jsmith@email.com
3                 8234              03/31/2017     125                    jdoe@email.com
4                 4675              03/29/2017     75                      jsmith@email.com



Trying to determine a way that each support person would get an email with an excel attachment with only the report records associated with his/her email address

using sample data john doe would receive

Recordid   customerid  orderdate        orderamount   supportpersonEmail
1                 1234              03/31/2017     100                    jdoe@email.com
3                 8234              03/31/2017     125                    jdoe@email.com


John smith would receive

Recordid   customerid  orderdate        orderamount   supportpersonEmail
2                 5678              03/29/2017     150                    jsmith@email.com
4                 4675              03/29/2017     75                      jsmith@email.com



I was thinking perhaps a data driven subscription??? If that is an option not sure exactly how

Thoughts????