Outlook - count number of emails in Sent Items folder and spit out results in Excel

[vhrame]

Graham, so i used your coding below to grab yesterdays date and i added a "-1" below but it didn't work?

If CDate(Format(olItem.SentOn, "dd/mm/yyyy")) = CDate(Format(Date-1, "dd/mm/yyyy")) Then 'test for today's messages