• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Outlook VBA help

vasim

Member
Sorry about asking an outlook question, in an excel forum, since this is fully related with VBA programming I thought I would get a help from here…….


Case: When I arrive in my office open outlook.


If a mail is received from xyz@go.com then fine else show a reminder that “Mail from xyz@go.com not received.


2nd condition…

If mail isn’t received from xyz@go.com till 05:30 then reminder to be displayed again.


If possible Saturday & Sunday excluded (its fine even if this doesn’t works).


Sender name will be always same, timing of 05:30 fixed….


Regards,

Indian
 
what's outlook?


You may find something here:

http://www.codeforexcelandoutlook.com/
 
What I would do is set up a recurring task with something like "Mail from xyz@go.com not received" in the subject. Have it occur at 5:30 PM every weekday. Then I would add an event handler (VBA) to check each incoming email. If the email address is xyz@go.com, then look for the task and mark it complete so it won't appear at 5:30.
 
Back
Top