Solution to store correspondence emails and documents

Murray Brown
Murray Brown used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
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.
ASP.net/VSTO Developer
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.
Distinguished Expert 2017

Commented:
Why not just accept your own answer?
Murray BrownASP.net/VSTO Developer

Author

Commented:
Thanks. I will do that
Murray BrownASP.net/VSTO Developer

Author

Commented:
I wasn't able to accept my own answer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial