+ Reply to Thread
Results 1 to 2 of 2

Set timer/clock on emails?

  1. #1
    Registered User
    Join Date
    02-04-2019
    Location
    Austin, Texas
    MS-Off Ver
    2016
    Posts
    1

    Set timer/clock on emails?

    Hello! So, in my line of work I have a 4 hour response time to any email I have that comes in. I am trying to find a way to basically set a countdown/timer on emails so when the email is getting close to the 4 hour mark, it's flagged. Anything to distinguish that I need to respond soon.

    Any ideas? I've spent all afternoon searching for Macros. Problem is, I can't use add-ins as it's restricted by the administrator so I have to use a VBA Macro or even a rule.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    2,027

    Re: Set timer/clock on emails?

    Welcome to the forum.

    Have a look at the code here: https://social.msdn.microsoft.com/Fo...-new-mail-item

    It uses the DateAdd() function (documented here) to set 8 minutes. You want 4 hours, so change the DateAdd("n", 8, Now) to DateAdd("h", 4, Now).

    Note: I have not tried this code myself, so cannot guarantee it.
    Regards,
    Aardigspook

    My internet connection can be intermittent, so sometimes I may not reply quickly to questions. Sorry - it's not personal and I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1