Here’s a non-macro way that requires MS Outlook and MS Excel (using Outlook 2002 and Excel 2002).
1. Open Excel and Outlook.
2. Switch to Outlook.
3. On the left side-menu, select “Other Shortcuts”
4. One the next left side-menu, select “My Documents”.
5. On the right side Explorer type menu structure, navigate to the directory that contains your files (double click the desired directory icon).
6. Select all the files with Ctrl-A (hold down the Ctrl key, then hit the keyboard key for the letter A; it does not matter if you use upper case “A” or lower case “a”).
7. After selecting the files, copy them to the clipboard by doing Ctrl-C (hold down the Ctrl key, then hit the keyboard key for the letter C).
8. Switch to Excel and select cell A1 in a blank worksheet.
9. Copy the files from the clipboard to Excel by doing Ctrl-V.
10. Delete any superfluous Excel columns.
Enhancements:
After step 5 above, in Outlook, right click the header bar (the one that has “Name”, “Author”, “Size” etc.). Experiment with the menu choices - “Field Chooser” and “Customize Current View”, particularly the option to filter the files to copy to Excel.
HTH
Mike