Hello,

I'm looking for a VBA code which will copy the outlook msg. emails from Share Drive to Online SharePoint.

For e.g.

I have a generic mailbox. I'll be manually copying the emails to a Share drive folder month wise.

Say I have a Partner Named as "XYZ Corporation", into which I'll have a folder named as 2020 and into this folder I'll be creating months folder each month.

This month I'll creating January Folder into which I'll copy all the .msg messages.

As there will be multiple partners names, so I want the macro to go to each partner folder check if 2020 folder exits, check if there is last month folder (here it will check January) and then copy all the msg. to SharePoint into that specific folder.

Output should be : Macro will check "XYZ Corporation" > into 2020 folder it will check last month folder > If January if found, copy that folder to SharePoint into "XYZ Corporation" > into 2020 folder.

Hope I'm clear with my requirement.

Please suggest. Thanks !