Solution to store correspondence emails and documents


I have been asked to build a solution that saves documents and messages emailed back and forth in Outlook into some sort
of repository that can then be accessed from anywhere. I am looking for suggestions on the best way to do this using Excel/Outlook/Access VBA code, webforms  and SQL.

My initial thoughts were to automatically send a copy (CC) message of all Outlook emails to an email address set up specifically for this as a starting point
then either store the documents on the company cloud server or in an folder or SQL database.

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
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.

that can then be accessed from anywhere
That pretty much eliminates Access as a tool.  Access only works as a solution when everyone is working on the same LAN or you are willing to implement something like Critrix to give access to the application over the internet.

You need to be a little more specific regarding what you need to use the data for and how people will access it.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
The documents are pdf, Excel and Word docs between gold mines and the drilling company that services them. This correspondence needs to be tracked for legal purposes. The drilling company needs to do the tracking. They use an web solution to compile data on their drilling. Storing the documents in an folder that they can they can then download via a web page is the best way I can think of.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Why not just accept your own answer?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks. I will do that
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
I wasn't able to accept my own answer
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.