Search and Flag the Emails in Outlook based on the Data in Excel (Subject column)

Hi,

Wanna to search the emails in outlook 2007 based upon the data in Excel. Daily I recevies N number of emails and I do export those mails into workbook.

Now what happens is I may get duplicate mails. So, have to check/search/flag the emails in outlook based on Excel, in which it has the old data, columns as From, Subject, Date, etc.

Please anyone's help will be appreciable that makes my work easier and useful with your code.

Please find the below code which I have worked, badly not working..

Please Login or Register  to view this content.

Hi Domenic,


Example.xlsx


Please find the attached with example data, in which by using the subject coulmn I have to search/flag the emails in outlook..

Eagerly waiting, Domenic...

Hi Domenic,

Thanks for the code, but as per my view that I have to find the emails based upon the Excel data. There is no matter that the date is not a concern. Based on the Subject column in Excel, have to find/track the emails in outlook..


Is there any posibility of the code? Please help me out in finding the solution to this problem..

Hope, you will guide me and sure will wait for the reply..

Hi Domenic,

Really I'm glad for you code, but here I'm getting an Error as

Run-time error '-2147352567 (80020009)':

Cannot parse condition. Error at ",".


at line
Set MItem = MItems.Find("[From] = " & strName)

Could you please suggest me..

Hi Domenic,

Thanks for the code. It's working..!!!! great..

Thanks,
Chaitanya