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
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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
that can then be accessed from anywhereThat 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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial