Select Outlook inbox plus sub folders and export to excel.

Great post - Copying all the emails from Outlook inbox plus subfolders to excel.

I also use a similar code to export all outlook emails to excel. However, I've never managed to get around the problem of how to select a specific folder and the Macro with then circle through all the folders and sub-folders within that, exporting my required info to excel.

See my code below. In my case I require the sender name, sender email, message subject, parent folder and date sent on. To get round my lack of knowledge, I have listed all the names of the folders i want the macro to look in into the code.

If any clever folks out there can help me get round this, I'd be very pleased.

Please Login or Register  to view this content.