+ Reply to Thread
Results 1 to 4 of 4

Export of Attachment "Names" to Excel from all Folders and Sub-folders

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    Miami
    MS-Off Ver
    2019, 365, MAC
    Posts
    45

    Export of Attachment "Names" to Excel from all Folders and Sub-folders

    Happy Thanksgiving eve friends. I hope this finds you all well.

    The title pretty much tells you what I am hoping to accomplish. Whether a tricK, a tip or VBA, I would like the ability to select a folder and return a list of all attachments in that folder and sub-folders. Of course it would be great for some additional details, like sender, date and the folder it was in, but the name of the attachment is the most important. No, I don't want to export it.

    Thanks for looking, thanks for responding and have a Happy Thanksgiving.

    Dianne

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Export of Attachment "Names" to Excel from all Folders and Sub-folders

    you have to loop the main folder and all its subs. to find a folder, select it from the MAPI, like this:
    Please Login or Register  to view this content.
    here is an example of looping subfolders in a main:
    Please Login or Register  to view this content.
    that code is a modified version of that found here by MS:

    https://docs.microsoft.com/en-us/pre...3(v=office.11)

    see the image below for the printout that the code gave me, based on my programs' PST info. PST = all outlook info for one profile.

    this post by me a while back is also relevant, and should give you everything else you need:

    https://www.excelforum.com/outlook-f...ml#post5428264
    Attached Images Attached Images

  3. #3
    Registered User
    Join Date
    12-02-2012
    Location
    Miami
    MS-Off Ver
    2019, 365, MAC
    Posts
    45

    Re: Export of Attachment "Names" to Excel from all Folders and Sub-folders

    Thank you so much. I havent gotten it to work yet, but I will go to the link you referenced and play. Have the nicest holiday. Thank you for your kindness. Dianne

  4. #4
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Export of Attachment "Names" to Excel from all Folders and Sub-folders

    sure thing. u2. post back if you get stuck. after all, isn't everything we do nothing but a bunch of ""playing to see what works""? LOL.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 05-26-2014, 07:47 PM
  2. [SOLVED] [NOT REALLY SOLVED]Open an explorer window in the current path, without "folders" showing?
    By Rhudi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2014, 01:17 PM
  3. Replies: 9
    Last Post: 11-19-2013, 06:17 AM
  4. probems creating folders: "......... folders already existed"
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2010, 03:04 PM
  5. Moved workbooks to folders now User form "Subsript out of range"
    By cheelie in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-01-2008, 06:51 PM
  6. Get rid of "Copy of..." folders in my "Open Files" box?
    By TOMinTEX in forum Excel General
    Replies: 0
    Last Post: 07-16-2006, 02:20 PM
  7. "Search for files and folders" option doesnot work for 100%
    By ECouwenberg in forum Excel General
    Replies: 7
    Last Post: 01-11-2006, 12:55 PM

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