Looking for a solution to automatically copy emails from Outlook deleted items into SharePoint

We are looking for a solution to automatically copy emails from a user's deleted item folder in Outlook 2016 (no access to Exchange, the solution must be local) into a SharePoint 2016 library while maintaining the associated metadata and mapping the email's metadata in the document properties columns. Currently, in order to perform this operation, we have an admin assistant manually dragging all emails from the deleted items into the Harmon.ie Outlook add-in every month, being a manual operation, errors can easily happen, since those emails have archival and business value to our organization we wish to eliminate human error. While Harmon.ie have an automatic email upload option, it rely on Outlook's rules which do not apply to the deleted items folder. Ideally the solution would integrate with Outlook and would either be able to simply move all deleted items into another folder based on a schedule where this second folder would be handled by Harmon.ie to bring them into the SharePoint library or automatically move them directly in SharePoint and map the metadata on the items.

Thank you,
Pascal LefebvreTeam LeadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

There isn't a proper way to achieve this as it's not a function of Outlook. If you had access to Exchange you can create export or archiving rules to achieve something along these lines but you've stated this isn't a option.

You may need to create a macro with one of the many automation tools out there, which 'record' your actions in a way that can be 'replayed' at a later date without interaction.

Autohotkey and robotask are worth a look but there are loads of these solutions out there.
Pascal LefebvreTeam LeadAuthor Commented:
Thank you Steve, we were thinking about the mactros too but I doubt it would go through our security team, I'll look into Autohotkey and robotask, never heard of them.

Thank you
Yea, Macros can be an issue so aren't always ideal. Those applications, and many others like them, basically replicate keyboard/mouse activity and allow you to create repeatable & automated actions. May be useful for what you need.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.