GI to show all email activity by Sales Rep

Hi all, 

I am trying to create a generic inquiry to report total email activity by sales report. The GI will be used for Dashboard widgets. 

What I have found, sales reps will sometimes use activity type “Email Response” if the Outlook addon isn’t working properly. The GI I am currently using based on the CRSMEmail table and doesn’t capture CRActivity data. I am having problems linking CRSMEmail and CRActivity where CRActivty.Type=’R’ (Email Response). 

Any help would be appreciated. 

Thanks,

Ehren