Copying all the emails from Outlook inbox plus subfolders to excel

[originally tacked on here, but moved as hijacking threads is not allowed]

Great post. 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.

Basically to read all emails in PostIN and all the subfolders of PostIn this suffices:

Please Login or Register  to view this content.

This code doesn't look into subfolders of subfolders in PostIN; but the code is so simple that you can easily adapt it to do so.

I think you merely need to change the start to:

Please Login or Register  to view this content.