download attachment from outlook email

[saurabhlotankar]

Hello All,

I receive an email everyday with a particular subject line in my outlook email account. It contains an attachment as a zip file.

I want to write a vba macro that will automatically download that attached zip file from that email.

for example

Subjectline : Test_one
I want to download the attachment from most recent email with subjctline "Test_one", then unzip it and save the unzipped excel file on my desktop.


Kindly assist.

Thanks.

[sintek]

Have a look at these links
http://stackoverflow.com/questions/2...ile-in-outlook
http://stackoverflow.com/questions/3...-onto-computer
http://www.vbaexpress.com/forum/arch...p/t-49064.html