How to Automatically Download/Save Attachments in Outlook to a Certain Folder Using [VBA + Rules]?

Sdílet
Vložit
  • čas přidán 28. 08. 2024

Komentáře • 37

  • @SwahiliSpicE
    @SwahiliSpicE Před 6 měsíci

    I am so glad I came across this video. I managed to use this process to download more than 2000 attachments received from a specific email address. This took about 2 hours of waiting time. Then, some of the attachments were zipped folders and I only wanted all PDFs from the email attachments. So I extracted all the files from the zipped folders at once (by selecting all the zipped folder first) which took another 2 hours to extract but and I can now search for .pdf and I have over 17k pdf files which I wanted on their own and not in folders. I was then able to just copy and paste them so I have one folder with 17k PDF files and no subfolders. I am going to extract the data in these PDFs (which I have a way of doing in less than a day) it will enable me to save the business that I work for around €1.5m. Thank you so so so so much!

  • @PoeLemic
    @PoeLemic Před 2 měsíci

    This is really usuable info. I am so glad that you showed this to us. I've been wanting to write something to save old emails out as text, and then delete those files. And, this idea helps.

  • @leelow85
    @leelow85 Před 11 měsíci

    Great work! One question, what can I do to also automatically save attachments from mails which are manually moved to this inbox?

  • @Quirkafleeg
    @Quirkafleeg Před 11 měsíci

    Thanks very much. Really helped me out.

  • @yashpalchopra9931
    @yashpalchopra9931 Před rokem

    Amir, super video. I have few questions. Could we make this naming conventions based+dates +separate file with the time rxd.

  • @gokmenaykut
    @gokmenaykut Před rokem +1

    Thanks , it helps a lot

  • @jks5657
    @jks5657 Před rokem

    Such a life saver!!! 10000 thanks!!

  • @magnet130
    @magnet130 Před rokem

    thanks for your nice video
    can I write a script that save all my emails (send and receive mails) to a certain folder automatically?
    or simply use (save as) feature automatically for all mails?
    I really appreciate all your tutorials and helps.

  • @raulmarines1047
    @raulmarines1047 Před rokem

    You are a genious!

  • @user-br4md8tm5l
    @user-br4md8tm5l Před 6 měsíci

    Hi, may I know is there any way to save all emails in my computer example in a folder in email format? I wish to search the folder with keywords and the email that i'm looking will pounce out?

  • @evetteprout9814
    @evetteprout9814 Před 7 měsíci

    How can you please run a script to save the attachments to a new Outlook Inbox Folder instead of to a computer drive? The attachments are not PDFs - they are emails that have been attached to an incoming email

  • @raushankumarpandey897

    Thanks for nice video...could you plz help me with if I need to download mail based on today date and others will be deleted in folder and this is a daily activity for me...Plz suggest 😊

  • @excused1277
    @excused1277 Před rokem

    Helpful video! What would be the additional code for every same title of email coming in, the new attachment will get downloaded and REPLACED into the specific folder?

  • @klchan988
    @klchan988 Před rokem +2

    Does the solution for the missing Run Script option apply to Outlook 365 ?

  • @GrasppowerA
    @GrasppowerA Před rokem +1

    So nice

  • @MiguelAngelEscajedaMedina

    Amit, great video, very well explained, it worked just fine! :)
    ...I'm struggling with several attachments which has same name since are all targeting to the same folder. So I tried to index it with the received date and the item potion. the "oAttachment.Index" is working since is part from the same attribute family, but when I want to take from the "MItem.ReceivedTime" which belong to a different one doesn't work. Could you help me to correct the code, please?
    Public Sub SaveAttachmentsToDisk(MItem As Outlook.MailItem)
    Dim oAttachment As Outlook.Attachment
    Dim sSaveFolder As String
    sSaveFolder = "C:\db\folder\"
    For Each oAttachment In MItem.Attachments
    oAttachment.SaveAsFile sSaveFolder & & "-" & oAttachment.Index & "-" & oAttachment.DisplayName
    Next
    End Sub

  • @michaelsmal7376
    @michaelsmal7376 Před rokem +1

    Hi, thanks for great video. I am saving multiple emails attachments with the same name. The script is then overriding the last attachment, meaning that only the last attachment is saved. Do you have a script that can rename the files if same name. eg : file, file(1), file(2) etc.

  • @shivanijoshi4857
    @shivanijoshi4857 Před rokem

    Sir can we also rename it at the tym of saving because as I am an employee of SCM department and get GRNs but i want to save that GRNs according to my invoice no.??
    Please reply if possible 🙏

  • @pastukas
    @pastukas Před rokem

    unfortunately, I can only do this once for a single contact. If I add another module, I am unable to add it to run script. I need a new project and it is impossible to do.

  • @ivankristianto7446
    @ivankristianto7446 Před 2 lety +1

    I can't find " run as script" . I have been set outlook /trus center/macro,but can't show too "run as script"

  • @berenicee5579
    @berenicee5579 Před rokem

    Can we do this by attachments name?

  • @letsexplorewithzak3614

    Possible to rename attachment datewise

  • @santhoshgowda5727
    @santhoshgowda5727 Před 8 měsíci

    Bro, is this work for Zip files?

  • @ravi123tube
    @ravi123tube Před 4 měsíci

    I am unable to find the Run a script Option

    • @mailsmartly
      @mailsmartly  Před 4 měsíci

      You can refer this mailsmartly.com/restore-missing-run-a-script-option-in-outlook/

  • @dipsxyz
    @dipsxyz Před rokem

    The code saved in Module does not appear for selection under 'Select script' after clicking 'Script'. What could be the reason?

  • @velurichiranjeevi3260

    Does this work for hyperlinks which we receive in outlook ?

  • @cornell9126
    @cornell9126 Před 2 lety

    𝓅𝓇𝑜𝓂𝑜𝓈𝓂 🙌