I am not able to use the above one on excel. if you can look into the sheet attached that will be helpful..
Moreover instead of this.. is their any VBA code which will highlight the email rows in inbox which is not yet responded & absent in sentitem email sheet?
Please find the attached Zip file ..
Searching a code which can highlight sheet1 row which is absent in sheet2 based on 3 conditions
Sheet1.Column B = Sheet2.A
Sheet1.Column C = Sheet2.C
Sheet1.Column E <= Sheet2.E
:)Hi Diane Thanks for the solution , will surely work on this...
I am succesful in bifurcating the emails
Sheet1 have inbox as per date range & sheet 2 have Sentitem as per date range..
I am stuck in below query..
Need a code which can highlight sheet1 row which is absent in sheet2 based on...
:(:(:(I am trying to build a code.. somehow got a wayout to download inbox & sentitems .. but it downloads entire inbox & sentitems.. i am not able to download via daterange.. more over how should i highlight those email which are not yest responded & doesnot exist in Sentitems
Need a VBA code which will help me doing below..
1) Download Microsoft Outlook Inbox data to Excel Sheet1 with date range
2) Download Microsoft Outlook SentItem data to Excel Sheet2 with date range
Now Highlight Sheet1 data which are not responded in Sheet2 .
Means those email which...