Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kwo
  • Order by date
  1. kwo

    Measure response time between receipt of Outlook email and the reply by date Overflow

    That's okay! Like I mentioned earlier, this wasn't a big issue. Thank you again for your help in debugging my issue!
  2. kwo

    Measure response time between receipt of Outlook email and the reply by date Overflow

    Interesting. I don't have any filters in place, and my team definitely has emails that hasn't been archived for a year. Maybe there's another setting in place for my team's email that I don't know of.
  3. kwo

    Measure response time between receipt of Outlook email and the reply by date Overflow

    Yes, but we're archiving anything older than 13 months. We cannot see any emails older than July 2019, so it seems strange to me that your VBA is only pulling in data all the way back to 03/09/2020.
  4. kwo

    Measure response time between receipt of Outlook email and the reply by date Overflow

    Andy-thanks for the reference! Now I better understand how to debug an issue in VBA Strongm-it works now!!! Thank you so much for your help! By the way, while I have you here, can you explain whether the code is only supposed to go back to a certain date? For some reason, every time I've been...
  5. kwo

    Measure response time between receipt of Outlook email and the reply by date Overflow

    You were right, strongm! After shutting off my computer, that issue went away. I followed strongm's steps, and it looks like the SentOn time is corrupt. When hovering my cursor over the VerbTime, I got 06/16/2020 10:06:00 AM. But when I do the same for SentOn, I got 01/01/4501, which I'm sure...
  6. kwo

    Measure response time between receipt of Outlook email and the reply by date Overflow

    Thank you, Strongm and Andy! This is such a strange problem to me. I didn't get a chance to make any changes to the VBA yet or get a chance to debug the ClockDrift issue, but when I tried rerunning the VBA to follow strongm's steps, I came across a different issue. I now have another error...
  7. kwo

    Measure response time between receipt of Outlook email and the reply by date Overflow

    Thank you Andy and strongm! How would you suggest I examine the values in debug mode? When stepping into the debug issue, all I see is the line that's causing the issue. Thank you!
  8. kwo

    Measure response time between receipt of Outlook email and the reply by date Overflow

    Hi strongm, I got the following error: "Run-tem error '6': Overflow" And my mistake, I got the error on Clockdrift = DateDiff("s", VerbTime, MsgItem.SentOn) Thank you!
  9. kwo

    Measure response time between receipt of Outlook email and the reply by date Overflow

    Thank you so much for responding! The following line of code caused an error for me. If Clockdrift >= 0 And Clockdrift < 300 Then ' Allow for a clock drift of up to 300 seconds. This may be overgenerous
  10. kwo

    Measure response time between receipt of Outlook email and the reply by date Overflow

    Following up on the following thread: thread707-1739523 I have been using this VBA to track the response time from my team's email. It has been working for the past couple weeks from my team's email, but for some reason, today, I have come across an Overflow message on row 162. Thinking there...

Part and Inventory Search

Back
Top