Save Excel attachment in a desktop folder with specified name automatically

[sethu29]

Hi support,

Daily i'm reciving an Outlook email with a subject named "Retail report" and the excel attachment named "Retailreport.xls". This report will reach me at 1:00 AM daily. My outlook will be always open. My requirement is to save this "Retailreport.xls" attachment in "C:\Documents and Settings\t21023\Desktop\Retail Report" folder automatically when the mail reaches me.


Please help me through VBA.

[sethu29]

In the above case, daily i'll receive the email with same subject and same attachment name. so i need to replace the old file with new file daily. Bcz the same file name will be already exist. i dont want to change the file name. My requirement is to save the file in the particular mentioned folder path with the same name. It means old file has to be replaced automatically. Please help