Consulting

Results 1 to 3 of 3

Thread: how do I Create New folder, save an email and all of its attachments to it??

  1. #1
    VBAX Newbie
    Joined
    Feb 2014
    Posts
    1
    Location

    how do I Create New folder, save an email and all of its attachments to it??

    So I have a problem and I have looked through forums and such and have yet to find an answer.

    Heres what I need a macro to do:

    1. Look into a folder and determine that highest numberd Folder there is and create a new folder one number higher. So if the highest number folder is labeled "11714" The macro will create a folder called "11715"

    2. Than it has to save a copy of the email to that folder.

    3. Than it has to download and save any attachments on the email to that folder.


    I have seen plenty of macros to save emails to folders or to save attachments but I have yet to find something that can scan a folder name and create a new one based on the number of the latest one. This is the most important part. If someone could help me figure that bit out Im sure I can get the rest done.

    ANY info at all would be helpful even just a link to a forum post that I haven't found or an article explaining this.

    Thanks

  2. #2
    Search for the Dir function with vbDirectory, and MkDir to create the folder.

  3. #3
    Look into a folder and determine that highest numberd Folder there is and create a new folder one number higher.
    are you meaning outlook folder, or windows folder?

Posting Permissions

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