Solution to store correspondence emails and documents

Hi

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, ASP.net 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 ASP.net folder or SQL database.

Thanks
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.

PatHartmanCommented:
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 ASP.net/SQL web solution to compile data on their drilling. Storing the documents in an ASP.net 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
PatHartmanCommented:
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
ASP.NET

From novice to tech pro — start learning today.