• 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.

Automating Outlook with excel to perform multiple task

shree@0106

New Member
Hi All,

I am new in VBA, look in for help to complete the project which get data from both inbox and sent item from outlook of current date and sort by received time . After getting data from mail items do the below task automatically:
If To address in sheet inbox belongs to any client listed from another sheet 3 then it will Check the subject line if subject starting with with RE or FW then leave that mail and look for another mail item. If subject line does not contain RE or FW then it start looking that particular subject text in sent item sheet. If found then do nothing else not found subject line entire row become red color and message box display.
any help in above mention would highly appreciated.
Here is some code in used ans also attaching the working file.
 

Attachments

Top