Read all folders and sub folders(under Inbox) from outlook mailbox
Create the same folder structure in Sharepoint
Then copy emails from each and every folder to sharepoint along with its metadata(email to, from, attachment etc)
Please suggest how can this be achieved using UiPath.
Are there any activities/packages readily available for outlook/sharepoint which can read folders and their data from outlook and replicate the same on sharepoint?
1 - Define all folders name in Config if those were predefined.
2 - Loop each folder name one by one and pass it in “Mail Folder” property of GetOutlookMail messages activity.
3 - Save each mail with save mail activity into respective folder.
Now to store each email to folder can be done in two ways
Either you create folder in local on run time and save the mail. (This will be inside folder foreach)
In the end start loading items to sharepoint folders.
Or
Directly save email on sharepoint. (This will be inside folder foreach)
We do have some packages for sharepoint.
Thank you for your inputs.
We did a little hackathon kind of event internally and figured out a solution.
Requirement:
Read all folders and sub folders(under Inbox) from outlook mailbox
Create the same folder structure in Sharepoint
Then copy emails from each and every folder to sharepoint along with its metadata(email to, from, attachment etc)
Please note: there can be n number of folders and folder names can be any name. Folders names are unknown and needs to do it in a way that works for every user this automation runs for. Plus not all folders might require replication.
Solution:
1)Get the extract of outlook mailbox in csv format. This will have all folders available and their relative path.
2)Read csv file and look for folders which are marked for migration.
3)Create same structure on sharepoint using UiPathTeam.Sharepoint.Activities package.
4)Loop through each folder name(fetched using step 2) in outlook.
5)Save all mail messages on local using Get Outlook mail message activity.
6)Upload saved messages one by one on sharepoint along with using its properties(to,from,subject,date etc)
