Macro to only deliver mails in a certin timeperiode RRS feed

  • Question

  • I am trying to set up a macro (mabye using VBA) for me and my colleges, ensuring a better work environment. This includes not sending out emails after working hours. (Or to be more precise - not receiving emails after working hours).

    I wrote a bit of pseudo-code , that I hope will help everyone understand what I want:


    If recipient address includes (text) check priority:

                 If piority is high – send email.

                 If priority is low – check current time of day

    If the time is between 6am and 4 pm – send email

    If the time is not between 6am and 4 pm – delay email until 6am - then send


    I believe the last two steps are the most difficult. I would appreciate any help.

    Thank you in advance.

    Friday, November 21, 2014 12:48 PM

All replies