We help IT Professionals succeed at work.

Solution to store correspondence emails and documents

125 Views
1 Endorsement
Last Modified: 2018-10-06
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

CERTIFIED EXPERT
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/VBA/VSTO Developer
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Distinguished Expert 2017

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

Author

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

Author

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