Windows 7 32bit 
Access 2010 32bit
I've been searching for this online for a long time and perhaps I'm not using the correct terminology for my searches, so I'm looking for someone to enlighten me or throw out any ideas for me to try.
My department handles all two-way email communication with our customers. We have 8 different email addresses that we use depending on the customer service issue. I'm looking for a way to continuously collect 3 pieces of data from every email that is received: 1) Date Received, 2) Time Received, and 3) To Field (which of the 8 email addresses it was sent to).
As you can imagine the collection of this data will help me look for trends to assist with staffing needs, as well as analyze build reports for the company to review. I've been working with my IT department on this but they are not sure where to start. My guess is that I need to have them collect the data as it is coming into the email server, right? I'm good with VB and I've built some VBA scripts recently that collect Outlook information, but these only work if the computer I'm using stays on all the time which is not always practical. We'd like to have this database stored on one of our shared drives which collects this data indefinitely from our email server.
Let me know if you have any ideas where to start or if you have any websites I can check out to get my IT guys started on this. The other option I have is to go with 3rd party software (example: http://emailtopia.com/index.php/prod...sponse-manager). But I'd rather try to do this in-house if possible. Thanks all!
Reply With Quote
