Added the email addresses from the Mandrill activity report into a table variable called `@mandrill` and ran the following TSQL to get all `TestimonialRequest`s for ShoreWest that were logged today:

`select RequestID,UserId,ClientName,Email,DateTimeStamp from TestimonialRequests where email in (select * from @mandrill) and userid like 'shorewest%' and datetimestamp > '2017-06-28';`

| RequestID | UserId          | ClientName                                            | Email                                 | DateTimeStamp           |
|-----------|-----------------|-------------------------------------------------------|---------------------------------------|-------------------------|
| 65421     | shorewest_1241  | [empty]                                               | dkane@northshorebank.com              | 2017-06-28 13:23:34.763 |
| 65422     | shorewest_2782  | [empty]                                               | jeffanderson53211@gmail.com           | 2017-06-28 13:23:35.513 |
| 65423     | shorewest_2782  | [empty]                                               | notperfectyet50@yahoo.com             | 2017-06-28 13:23:36.170 |
| 65424     | shorewest_1619  | [empty]                                               | rgerstad@gerstadbuilders.com          | 2017-06-28 13:23:36.933 |
| 65425     | shorewest_1245  | Aaron M. Andreshak                                    | aaron.andreshak@faithtechnologies.com | 2017-06-28 13:23:37.853 |
| 65426     | shorewest_29005 | Aideliz Guadalupe                                     | guadalupeaideliz@yahoo.com            | 2017-06-28 13:23:38.570 |
| 65427     | shorewest_38130 | Alice C. Lundstrom                                    | alundstrom47@gmail.com                | 2017-06-28 13:23:39.383 |
| 65428     | shorewest_550   | Allison J. Peterson                                   | areeves@uwalumni.com                  | 2017-06-28 13:23:40.117 |
| 65429     | shorewest_5282  | Amanda E. Ludwig                                      | aeludwig07@gmail.com                  | 2017-06-28 13:23:40.803 |
| 65430     | shorewest_3475  | Amanda Grant                                          | admrkgrant@sbcglobal.net              | 2017-06-28 13:23:41.503 |
| 65431     | shorewest_1243  | Andrea Donoho AKA Andrea Wittenberg NKA Andrea Hatton | drea2791@gmail.com                    | 2017-06-28 13:23:42.143 |
| 65432     | shorewest_2028  | Andrea L. Krueger                                     | andreakrueger79@yahoo.com             | 2017-06-28 13:23:42.847 |
| 65433     | shorewest_722   | Andrew J. Josten                                      | andrewjosten@att.net                  | 2017-06-28 13:23:43.563 |
| 65434     | shorewest_1264  | Andrew M. Ausmus                                      | ausmusam@gmail.com                    | 2017-06-28 13:23:44.280 |
| 65435     | shorewest_3409  | Andrew P. Krueger                                     | akrueger@wipfli.com                   | 2017-06-28 13:23:44.997 |
| 65436     | shorewest_8654  | Aneta Zafonte                                         | zafonteaneta@gmail.com                | 2017-06-28 13:23:45.653 |
| 65437     | shorewest_3038  | Angel Hernandez Acosta                                | angel.acosta0711@gmail.com            | 2017-06-28 13:23:46.387 |
| 65438     | shorewest_2782  | Angela M. Vert                                        | tomvert@prodigy.net                   | 2017-06-28 13:23:47.353 |
| 65439     | shorewest_5243  | Anjali Peterson                                       | anjalip@ameritech.net                 | 2017-06-28 13:23:48.103 |
| 65440     | shorewest_2501  | Ann K. Haugen nka Ann K. Scherzinger                  | annscherzinger@yahoo.com              | 2017-06-28 13:23:48.790 |