Results 1 to 20 of 22

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

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #20
    VBAX Regular
    Joined
    Sep 2019
    Posts
    23
    Location
    Graham, I had a work colleague look into this and this is the coding that worked:

    If CDate(Format(olItem.SentOn, "mm/dd/yyyy")) <= CDate(Format(Date - 1, "mm/dd/yyyy")) Then 
        If CDate(Format(olItem.SentOn, "mm/dd/yyyy")) = CDate(Format(Date - 1, "mm/dd/yyyy")) Then
           strDate = Format(olItem.SentOn, "mm/dd/yyyy")
    I truly appreciate your help and thank you for everything you have helped me with.
    Last edited by Aussiebear; 02-17-2025 at 11:12 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •