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

Поділитися
Вставка
  • Опубліковано 20 жов 2024

КОМЕНТАРІ • 37

  • @SwahiliSpicE
    @SwahiliSpicE 7 місяців тому

    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 4 місяці тому

    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.

  • @イチカ-g4j
    @イチカ-g4j 8 місяців тому

    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?

  • @leelow85
    @leelow85 Рік тому

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

  • @evetteprout9814
    @evetteprout9814 9 місяців тому

    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

  • @yashpalchopra9931
    @yashpalchopra9931 Рік тому

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

  • @Quirkafleeg
    @Quirkafleeg Рік тому

    Thanks very much. Really helped me out.

  • @klchan988
    @klchan988 2 роки тому +2

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

  • @magnet130
    @magnet130 2 роки тому

    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.

  • @shivanijoshi4857
    @shivanijoshi4857 Рік тому

    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 Рік тому

    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.

  • @michaelsmal7376
    @michaelsmal7376 Рік тому +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.

  • @excused1277
    @excused1277 2 роки тому

    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?

  • @raushankumarpandey897
    @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 😊

  • @MiguelAngelEscajedaMedina
    @MiguelAngelEscajedaMedina Рік тому +1

    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

  • @jks5657
    @jks5657 Рік тому

    Such a life saver!!! 10000 thanks!!

  • @ivankristianto7446
    @ivankristianto7446 2 роки тому +1

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

  • @gokmenaykut
    @gokmenaykut 2 роки тому +1

    Thanks , it helps a lot

  • @berenicee5579
    @berenicee5579 Рік тому

    Can we do this by attachments name?

  • @velurichiranjeevi3260
    @velurichiranjeevi3260 Рік тому

    Does this work for hyperlinks which we receive in outlook ?

  • @raulmarines1047
    @raulmarines1047 Рік тому

    You are a genious!

  • @ravi123tube
    @ravi123tube 5 місяців тому

    I am unable to find the Run a script Option

    • @mailsmartly
      @mailsmartly  5 місяців тому

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

  • @letsexplorewithzak3614
    @letsexplorewithzak3614 Рік тому

    Possible to rename attachment datewise

  • @santhoshgowda5727
    @santhoshgowda5727 10 місяців тому

    Bro, is this work for Zip files?

  • @dipsxyz
    @dipsxyz Рік тому

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

  • @GrasppowerA
    @GrasppowerA 2 роки тому +1

    So nice

  • @cornell9126
    @cornell9126 2 роки тому

    𝓅𝓇𝑜𝓂𝑜𝓈𝓂 🙌