By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,646 Members | 2,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,646 IT Pros & Developers. It's quick & easy.

Monitoring incoming e mail

P: 7
I have created a form in excel using VB, the form is to monitor workload and how long taks take to complete.
My department currently works from 6 inboxes and monitoring work that is coming in is a bit of a nightmare, what i would like is if an e mail comes into any one of the inboxes i then have a counter within excel sheet counting each mail that is coming into the inbox i do not want the counter deducting each time an e mail is looked at however.. can anyone help...please.....
Nov 8 '06 #1
Share this Question
Share on Google+
3 Replies


Expert 5K+
P: 8,434
I have created a form in excel using VB, the form is to monitor workload and how long taks take to complete.
My department currently works from 6 inboxes and monitoring work that is coming in is a bit of a nightmare, what i would like is if an e mail comes into any one of the inboxes i then have a counter within excel sheet counting each mail that is coming into the inbox i do not want the counter deducting each time an e mail is looked at however.. can anyone help...please.....
I doubt that I can help much, but I do have a question or two
  • Are these Outlook inboxes?
  • Can you be more specific on what you want from us? Ideas for particular parts of the task? If so, which parts?
  • Which parts of the task are supposed to be automated, which parts manual?
Nov 8 '06 #2

100+
P: 1,646
I have created a form in excel using VB, the form is to monitor workload and how long taks take to complete.
My department currently works from 6 inboxes and monitoring work that is coming in is a bit of a nightmare, what i would like is if an e mail comes into any one of the inboxes i then have a counter within excel sheet counting each mail that is coming into the inbox i do not want the counter deducting each time an e mail is looked at however.. can anyone help...please.....
Hi, I guess this is a MS Exchange problem. If you have Exchange running the emails you can create exchange objects in your code and mess around with anything you like

Good luck
Nov 8 '06 #3

P: 7
I doubt that I can help much, but I do have a question or two
  • Are these Outlook inboxes?
  • Can you be more specific on what you want from us? Ideas for particular parts of the task? If so, which parts?
  • Which parts of the task are supposed to be automated, which parts manual?
Hi

The outboxes in question are from Outlook
I would like to have a set up where by each mail that comes into one of the inboxes is then counted in Excel so if i have 25 emails, 5 in each in each inbox i can look at excel and it will tell me that i have 5 e mails in each of the inboxes.
Nov 9 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.