DECLARE @StartDate DATE = '20160101'      

DECLARE @EndDate DATE = '20160531'


DECLARE @User NVARCHAR(128) = 'first.last@yourdomain.com'


SET @EndDate = DATEADD(day, 1, @EndDate);

PRINT @StartDate

PRINT @EndDate


SELECT t.LogDate AS [Time Stamp]

                 , t.Sender

                 , t.Subject

                 , t.Size

                 , r.Recipient

 

                 --, *

FROM Traffic t INNER JOIN MessageList m ON t.TrafficId = m.TrafficId

                          INNER JOIN RecipientList r ON m.RecipientListId = r.RecipientListId

WHERE t.[Sent] = 1

                 AND t.Sender = @User

                 AND t.LogDate >= @StartDate

                 AND t.LogDate < @EndDate

ORDER BY [Time Stamp]