Forum Discussion
Print a List of Outlook Mail Folders
I know this reply is two years after the original post, but having recently encountered a similar need, I decided to post the related solution. Maybe others searching for this same piece in the future might find this and save themselves some time and frustration.
My need: To take the eMail view within a given folder and copy it to a text file or spreadsheet. No, this does not show the list of folders, but merely the contents of a single selected folder.
My Outlook version is from MS Office Professional Plus 2016, 32-bit. I don't know if this works in earlier versions like 2010 or 2007. (Yes, there are people out there still using their old trusty 2007!)
Steps:
1. For a selected Outlook eMail folder, change the View Settings to display only the columns you wish to copy to your spreadsheet (or other file). There are dozens of fields (column headers) within Outlook that can be displayed. After the desired view has been created, if you'll want to repeat this copy process on other folders, I recommend you save the Current View As to a New View. Going forward you'll be able to quickly select the saved view whenever you need it.
2. Within the Outlook eMail folder, select the eMails you wish to be included in your spreadsheet. CTRL+A to select all, select (highlight) one and then hold the SHIFT key before selecting the last eMail to be included, or hold the CTRL key while individually selecting the desired eMails to be included.
3. Right-click on one of the highlighted emails and choose COPY. This copies the view as text onto the Windows clipboard. If you right-click on a non-highlighted email (or row) you'll lose your selection and you'll have to repeat step #2 again.
4. Open Excel (or other program) and PASTE the copied text. In my case this resulted in a table with the column headers From, To, Subject, Received, Size and the several hundred rows of visible text from within the selected Outlook eMail folder.
Here's a source link where I found some of this info:
https://learn.microsoft.com/en-us/answers/questions/734180/how-to-export-outlook-message-headers-to-excel-as
Hopefully this will help someone in the future.
Should I find a solution to copying the list of folders, I'll come back and share the info.
4dgeorge If you need a list of folders, you need to use VBA.
Print a list of your Outlook folders (slipstick.com)
If you want mail exported to excel by folder, you can use a macro to export the mail too.
- 4dgeorgeAug 12, 2024Copper ContributorThanks for the very quick response! I'll save those for future reference.