+ 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,270

    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)

Similar Threads

  1. [SOLVED] Real time clock or timer
    By prbr in forum Excel General
    Replies: 7
    Last Post: 09-17-2018, 03:40 AM
  2. Timer off system clock
    By PadraigD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-27-2015, 04:25 PM
  3. Formula for a clock timer
    By mlbdc2012 in forum Excel General
    Replies: 1
    Last Post: 02-04-2015, 02:42 PM
  4. Count down timer clock with alarm. please help.
    By carhoon13 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-12-2013, 04:54 PM
  5. Need VBA to create a clock/timer
    By compumast in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2012, 02:20 AM
  6. [help]clock timer using ecxel
    By saintm1kk1 in forum Excel General
    Replies: 0
    Last Post: 06-14-2012, 12:31 PM
  7. Timer in cell (digital clock)
    By most_lost in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 04-18-2012, 01:10 AM

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