Right now, they're using SSRS, but I was told they're have a separate report for each and every rep... Basically they're saying they can't loop through a table and send individual emails.. Me, I'm not familiar with SSRS so I can't say how or even if it can be done. If you can point me in a direction on how it to accomplish this in SSRS, it would be great. If not, I need to figure on the old school way of doing it was s SPROC.

Thanks!