Dear Team,
I want to download outlook mail attachment with specific file name ("Calibration") on current month and create the new folder on name of current month and save the files to on that folder.
For example when i click button first it should search what ever the mail attachment received in the name of "Calibration" on current month (EXample: May) only and create sub folder with current month name to C:\Users\SENTHIL KUMAR P\Desktop\SUmmary\ (Month Name) and save all that file to the folder.
I tried the bellow code. This code is downloading entire mail attachment. I dont know how to change this code as per my requirement.
Sub AttDownload()
For Each it In CreateObject("Outlook.Application").GetNamespace("MAPI").getdefaultfolder(6).items
For Each at In it.attachments
at.SaveAsFile "C:\Users\SENTHIL KUMAR P\Desktop\SUmmary\" & at.FileName
Next
Next
End Sub
Can any one please help me to solve this.