+ Reply to Thread
Results 1 to 9 of 9

outlook functions

  1. #1
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    outlook functions

    oh great, now we're into outlook in its many guises. i foresee many hours being spent trying to explain things, bring it on! now a few more hours of my life can be usefully employed.

  2. #2
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    hey martin if youre a wiz
    id like to be able to add a 100 folders into a specific folder that will be begin
    j5800 through to j5899
    can u help?

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    no! i hate outlook!
    especialy users and permissions

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531
    Please Login or Register  to view this content.
    Change code in RED to be the parent folder in which the new folders are to be added.

  5. #5
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    thanks donkeyote
    im not sure if im doing this right
    in my inbox
    i have a folder called J5800
    i then went to tools > macro and created the macro you kindly supplied
    i then ran the macro but i got this message
    run time error 2147221233 (8004010f)':
    the operation failed. an object could not be found
    and highlights this code
    Set OL_FL = OL_NS.Folders("Personal Folders").Folders("J5800")

    im guessing im doing somethng wrong rther than your code
    and would appreciate if you could point me the right way

    regards
    Last edited by stevesunfold; 12-28-2008 at 09:03 AM.

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531
    Confused... I thought per your OP you were adding 100 folders namely J5800 to J5899 to a given folder in your mailbox... whereas your latest post implies folder J5800 already exists -- are you able to clarify the "tree" structure you're attempting to create ?

  7. #7
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    hi donkey
    this is weird because i have now gone to it and they are there
    i then went to try and add from 5900 and they went in ok
    except 5901 is missing
    my tree is just inbox
    although i would like it to be
    inbox > j5800 > then the 100 folders
    inbox > j5900 > then the 100 folders
    thanks for your help
    this is the code i have
    Please Login or Register  to view this content.
    im happy to put the initial folder in ie j5800 ( that holds all between 5800 and 5899 ) and then add the folder j5900 so that the next 100 go in that folder

    im guessing that would change to line
    Set OL_FL = OL_NS.Folders("Personal Folders").Folders("Inbox")
    probably to somthing like
    Set OL_FL = OL_NS.Folders("Personal Folders").Folders("Inbox").Folders("j5900").
    ?
    regards
    Last edited by stevesunfold; 12-28-2008 at 11:25 AM.

  8. #8
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531
    Below is code that would iterate 5800 to 5900 and add xx01 to xx99 as sub folders thereof
    (ie create 5800 then add 5801 to 5899 as subfolders, then create 5900 and create 5901 to 5999 as subfolders).

    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    donkeyote
    thats amazing and works fine
    thanks so much
    regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1