Avatar of Murray Brown
Murray Brown
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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
ASP.NETMicrosoft AccessMicrosoft ExcelMicrosoft WordMicrosoft Office

Avatar of undefined
Last Comment
Murray Brown

8/22/2022 - Mon
PatHartman

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.
ASKER CERTIFIED SOLUTION
Murray Brown

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
PatHartman

Why not just accept your own answer?
Murray Brown

ASKER
Thanks. I will do that
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Murray Brown

ASKER
I wasn't able to accept my own answer