Consulting

Results 1 to 4 of 4

Thread: MS Outlook 2010 Save Attachment to folder

  1. #1
    VBAX Newbie
    Joined
    Sep 2012
    Posts
    2
    Location

    MS Outlook 2010 Save Attachment to folder

    Hello everybody,

    I need some help with saving attachments to a folder on my harddrive. Every day I receive emails from my scanner (PDF files). The attachment are customers with a unique number. I have 11 folders on my harddrive and I have to sort out wich attachment has to be saved to one of 11 folders.

    Is there a way with VBA that I have a option, command or window that says;

    - Where do you want to save your file? (So I need to give a location)

    - What name do you want to give your folder? (I have to save the file in on of the 11 folders)

    - What name do you want to give your file? (That will be the file in the subfolder of one of the 11 folders)

    I know, it sounds crazy, but I have to organize my customers every day.

    I hope someone can help me with this... Thank you very much..

    Kind regards,

    Imad

  2. #2
    VBAX Mentor
    Joined
    Feb 2009
    Posts
    493
    Location
    How do you determine what folder and filename you want? It would be easier if you know in advanced based on certain criteria those details and then you could skip the dialogs. To be honest it seems if you are going through dialogs it is just as quick to right click the attachment and click save as.
    -----------------------------------------
    The more you learn about something the more you know you have much to learn.

  3. #3
    VBAX Expert JP2112's Avatar
    Joined
    Oct 2008
    Location
    Astoria, NY
    Posts
    590
    Location
    Please provide an example. At the very least, we need
    • Email subject
    • Attachment filename
    • Name of folder(s)
    • How you determine where a given file is saved
    • What happens if you get a PDF for a new customer and you do not have a folder for them
    Regards,
    JP

    Read the FAQ
    Getting free help on the web
    My website
    Please use [vba][/vba] tags when posting code

  4. #4
    VBAX Newbie
    Joined
    Sep 2012
    Posts
    2
    Location
    Quote Originally Posted by JP2112
    Please provide an example. At the very least, we need
    • Email subject
    • Attachment filename
    • Name of folder(s)
    • How you determine where a given file is saved
    • What happens if you get a PDF for a new customer and you do not have a folder for them

    HelloJP,

    Thankyou very much for your reply. The emailsthat I receive from the scanner have always a subject: “SCAN KYOCERA”. The nameof the attachments (PDF) are always “SCAN1542_000.pdf” and off course thenext one will be added with a number further, for example “SCAN1543_000.pdf”.

    Therootmap of the subfolders is C:\ECD and in this root I have got 11 maps with:


    · 01R… (C:\ECD\01 R…)

    · 02H… (C:\ECD\02H…)

    · 03E… (C:\ECD\03 E…)

    · 04A… (C:\ECD\04 A…)

    · 05L… (C:\ECD\05 L..)

    · 06D… (C:\ECD\06 D..)

    · 07O… (C:\ECD\07 O..)

    · 08Z… (C:\ECD\08 Z..)

    · 09A… (C:\ECD\09 A..)

    · 11H… (C:\ECD\11 H..)

    · 12D… (C:\ECD\12 D..)

    Atthis moment I have to open each PDF file, check into the PDF which customer itis, what number the customer have and then I have to save it in one of the mapyou see above.

    Forexample; I receive a PDF and thecustomer name is “TEST” with customer number “8 21546” I have to save it like;

    C:\ECD\08Z...\8 21546\TEST.pdf

    Soevery customer I receive from the scanner should be an new map in of thefolders above.

    Ihope I am clear enough .. Is this possible to do it with VBA?

    Regards,

    Imad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •