Outlook Macro to gather email data from different subfolders into same worksheet

[M.A]

Hi guys,

This is my first post so please be gentle with me :P

So I have this VBA code for gathering email data which I found on the internet and made some minor adjustments to it to fit my needs. I still have one problem which I have been unable to figure out by myself so I was hoping you guys could help

What the code does:

User chooses which mailbox to gather data from
>New excel workbook is opened
>Email data from main folder is extracted

>New excel workbook is opened
>Email data from first subfolder is extracted

>New excel workbook is opened
>Email data from second subfolder is extrated etc. you get the drill.

What I would like it to do is to gather all the email data into the first workbook and everything on one sheet instead of having it open sometimes 20-30 separate workbooks. How would I need to alter the code in that case?

Please Login or Register  to view this content.

Thanks for the help in advance!

Br,
M.A

[skatonni]

Move the code that creates new workbooks out of the loop.

Please Login or Register  to view this content.

[M.A]

Hi Skatonni,

I had the same idea but I was not able to make the code work after removing the code out of the loop.

I just tested this, works great! Thank you for your help!

Br,
M.A