Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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.

Avatar of PatHartman
Flag of United States of America image

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.
Avatar of Murray Brown
Murray Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Why not just accept your own answer?
Avatar of Murray Brown


Thanks. I will do that
I wasn't able to accept my own answer