VBA to download email attachments from Outlook with multi Criteria. Real-life Automation Project 

Hello Pamai, Never thought I'd leave a comment on such a video, I usually grab what I look for to help myself, but this was the only method that worked for me amongst many. God bless!

Hello Pamai, It is a top-notch tutorial. Thank you so much. No waste of time. Every step is carefully programmed to make the listener understand and move from the well-learned previous step. You are great! May God bless you.

very neatly explained, step by step with error handling Thanks for splendid class

You are superb and you rock. Everything is so crisp and clear. I have subscribed you already and wish you all the best.

Great tutorial, the most important topic which is explained very well step by step

Thanks a lot. This was something I was looking for. Very informative video thanks again

This is very impressive. Thank you so much it has been very helpful.

Thank you. I found it very informative.

Thanks man, it was the thing I was looking for, thanks a lot

Great job with the tutorial Sir! 👏👏👏

Thank you sir for very informative detailed tut. Please upload the project or share via email. Keep up good work!

Genau das, was ich brauche !! That's exactly what I need !😁

Thank you so much Pamai. I will try the code and hope will work. I'm still new in VB. Good luck and God bless you.

Thank you for your tutorial, very helpful.

This is really good. Thank you so much.

Mind blown bro... You explained in most simple way... Surprised to see your subscriber count... Love from India

Great tutorial my friend. 😍

Thank you brother

You are so good

Hi Pamai, Excellent video and very logical flow of programming there. I have one question if we receive mails from different people with those common parameters, can we save the attachments in separate folders grouped based on the incoming mail id.

Wonderful video! I’m using it for my job and love it. But one question, is there a way to have the code wait for ATP Scanning? I have the application waiting for the time can vary drastically. Thanks so much!

SuppppperLike!!!!

Hi, this is an incredible tutorial. Plz also let us know how it can be organized in local drive folders based on sender email address

Many thanks for this video you teach excellent. Could you please make a video to make addins because my ribbonx not working and I don't know how to use custom UI

Amazing and thank you so much. It really helped me a lot. Just wanted a small assitance - how can i put a condition to check the attachment type like pdf or txt. I tried doing that but struggling to get one.

Thanks for this knowledgeable tutorial, I have one question, how can I fetch the value from the property/column "Mention" from a mail? like we fetch Sender, Subject etc. Thanks in advance for your help. Thanks Kashif

Hello! How are you? Thanks for sharing! Just a question: my attachment (an Excel file) is encapsulated inside a ZIP file. Is there a way to automatize the file's extraction from the zip? After the file has been put inside a folder, I'll performe others tasks with a VBA code to extract information from the file to another Excel file. I hope you can help me. Thanks a lot!

Hello! Thank you so much for this video, tell me please if I can write this program on outlook's VBA directly.if it's possible could you tell me what i have to change please. Thanks for your time Bye

It’s very good, I need more information like , I need to save attachment from the email in particular excel spreadsheet then email and attachment needs to print. Do you have any idea

Hello Pamai, thank you for your video. Can you please explain how to rename those files?

Thanks for this session..how we can extract outlook attachment with respective members and latest email attachment ( 2 conditions)

Thanks lot it's it is very nice how can we add multiple sender name to download the attachment

Wonderful and clear tutorial. I was trying to use this. it is showing an Microsoft Visual Basic for Applications, Compile error:, User-defined type not defined. It highlights "olApp As Outlook"

Thank you for the excellent video. Is there any way to also save each outlook email in local folder? Thank you

Hi Pamai, will something similar works on daily basis with different outlook folders moving all attachments to specific local or even better sharepoint folder ? Thank very much.

This is very helpful. I have a report that is emailed to me multiple times a day. The attachment file name does not change. Is it possible to save the attachment with the received time?

Great project, I built an richtextbox in excel vba to send email, do you know if is possible to create an email app without use Outlook?

Do you have any video on downloading all the attachments from multiple outlook emails in a folder without using excel?

Thanks a lot for this awesome tutorial. Can you share the code?

Hi, Thanks for the video tutorial, I hope you are doing good, staying safe & healthy, I have one question regarding outlook mails, can I move all the mails (mails that category is blank) from a outlook folder to another outlook folder at once like copy and paste not through loop, move bulk mails at once, is this possible? if yes? please help me. Like if we do manually then will go to that folder then apply filter then select those filtered mails and drage those mails to another folder, at once we moved all the mails to difference folder. How can we do this through Excel VBA? Please help me to resolve this query. Thanks Kashif

Hello, great video! I have a question...what if I am not the admin, how can I replace this in the code? so simply try to replace [admin] with "my email address"?

Hi, could you pls help me to understand on olitem as object and no variables for olmail right ?

Hello Sir - There is one question in VBA how to capture non-english script langauages, like chinese or some other non-english script languages...is there any variable or system to convert the same

Hello Sir - Hope all Fine, i want to make it automatic or real time download as & when email received into outlook into excel (with automatic next email option to avoid email line duplication). if we put this email trigger into excel vba workbook as event. it will work or not?

great tutorial, i have a problem though, i have about 4000 mails in the folder, how do i not loop over all the items in the folder?

Hi can you help how to download only unread file if there is read file will not be downloaded help will be highly appreciated

For anyone else struggling with this DO NOT USE "&" during the conditional if statements USE "AND". Multiple conditions within the If Statement will not work when trying to include parameters if you utilize "&."

please how to export emails from a sender to a floder in hard drive as msg file with vba?

Hello, I do not have any information about coding. If I ask you, can you help me with outlook vba?

Hey,is it possible to send emails if there is conditions! Exp: if range ("A4")= "true" then Range ("b4:f6"). select Selection.copy So the .body="good morning" For the above code it's working fine if I change the condition to false it's showing the same good morning I want change that to good evening if range ("A4")= "false" then Range ("b4:f6"). select Selection.copy .body= "good evening"

5:43 How do you hide all the other cells?? I guess its a shortcut! what shortcut is it tho??

is it possible to extract from outlook in excel the date received and the date that i replied to an email?

It’s working fine but I’m not able use this for shared mail box . Please help me for this issue

Thank you for this great video, I have a quick question, I tried "If mailitem.ReceivedTime > [Sheet1].[Date].Value & mailitem.SenderEmailAddress = [Sheet1].[fromSender].Value Then" However it does not download the attachments. But if I run the if statements for each alone, it does based on the criteria. Any help? Thank you

Hi, This tutorial is really helpful but when i am doing name range reference and call it in my code it is throwing me error "run time error 424 Object required

Hi i have tried the above everything looks fine but the attachment is not getting saved

how to send image in the email body?

Hello do you have a code for saving attachment based on email subject??

Do you have a tutorial for gmail attachment?

how do I rename the file, while downloading the specific folder?

Team , I am getting object error in admin mailbox line

Thank you for this coding. I am getting error when I use admin in the coding. Pls help me

Whats the MAPI folder whats that

Is it possible to do the same from outlook webemail..?

Can you send me the codes used in this tutorial?

you have worked hard for this video but you hae not recored how it is working

Black screen not useful for code

Hi, I get a runtime error here: Set olFolder = olNS.Folders([Admin].[Mailbox].Text) - it says an object can not be found, but the inbox address is there when I do ?[Admin].[Mailbox].Text in Immediate. I also had the type error instead of this before adding the .Text

Hi, I hope you are doing good and staying safe, I have one question in outlook, in a folder there are multiple mails and in this folder have many mails that have the subject "TestMail_1" and my requirement is that if the mail's subject is "TestMail_1" then I want to move this mail to another folder, and for this I am applying loop in this folder, this loop is not moving all the mails that have the subject "TestMail_1" it is only moving some of the mails not all, I don't know why but it is skipping some mails. For Testing purpose suppose in the source folder have 9 mails with following subject. 1st mail Subject: TestMail_1 2nd mail Subject: TestMail_5 3rd mail Subject: TestMail_1 4th mail Subject: TestMail_4 5th mail Subject: TestMail_2 6th mail Subject: TestMail_1 7th mail Subject: TestMail_1 8th mail Subject: TestMail_1 9th mail Subject: TestMail_1 Code: Set outFolderSource=namespace.Folders("emailaddress").folders("SourceFolder") Set outFolderDestination=namespace.Folders("emailaddress").folders("DestinationFolder") For each outMail in outFolderSource.Items If outMail.Class=olMail Then If Instr(outMail.Subject, "TestMail_1")>0 then outMail.Move outFolderDestination End if End if Next outMail My kind request to you that please help me to resolve this issue. Thanks Kashif