Save Outlook Attachements based on Date & file/Subject name

Hi Experts,

I am here with one query below is my requirement.

almost I have done with my query but I am unable give finishing to the code

Note: In mails Subject & File Name will be same (User will move related to this email to particular folder (Price List Macro))

Requirement is:

1. In attached sheet (Control Tab) list of File/Subject name is there in Column D
2. User will enter date in H2 cell (on that date macro should look in to that outlook folder )

Macro should loop from D2 to last row in that received date where user enter in H2 cell. If macro find that file in outlook folder then that file should save in desktop path (Path: H3 Cell) and in next cell (E Column) status should be Received or else Not Received.

attached file will give complete info. I have written macro if my written macro is not correct then u can change which will perform my task.

Thanks in Advance !!

Any Update from any one !!

Hi Guys !!

successfully I able to make perfect code for my query !!!

Thank You !!

Hi Naveed,

Can you post your perfect code?

Hi xladept

yeah sure here is the code

Please Login or Register  to view this content.

please have review and let me know if anything I missed in it or written un-necessary lines............