The title being very abstract and stuff, I think I need to explain in more detail the context and what I want to do here.
I'm using Outlook 2003 on a company server and we receive almost 100 emails a day per person (10 people here so 1,000 emails a day) and some of those emails we want to collect info from. What I'd like to do is for a person to be able to click on a button inside an email as if saying "I want to add this email to the database".
A little Message (or input) Box would open with 3 possible options:
- Good feedback
- Poor feedback
- Cancel
According to what the option would be selected (all options apart from 'Cancel'), a series of information would be collected:
- Email address of the person the email was sent to
- The date of the email
- The time of the email (rounded up or down to the closest half-hour so if 10:12am it would give it as 10:00 and if 10:16 it would give it as 10:30)
- The title of the email
Then, with that Data, it would go onto a SQL database or Excel 2003 File. Depends which is easier...
Would copy that data into different columns (new row of course):
- Email address of the person the email was sent to
- Date of the email
- Rounded time of the email
- Good feedback or poor feedback
- Title of the Email
The only thing I want the other people to see is the box where they make a choice whether or not the email was good or poor feedback. The rest must be unseen to them but I must be able to access that SQL Database or Excel File and be able to compile the Data into Charts and stuff like that.
Do you think this is possible?
Start Free Trial
