Using Outlook to Count Responses
Here's a productivity tip that will save you a lot of time and trouble if you need to collate responses from staff for any reason, especially if you work for an organisation with a lot of staff.
Case Study: I worked for a financial institution with 3,000 plus employees and had to identify how many employees needed compulsory training in certain legislation so that we could plan and resource the training.
I emailed everyone within the centre with a request that if they had not completed the training within the last three months, they were to reply to my email without changing the subject line. They were to reply by a certain deadline ... any queries were to be sent via a new email addressed to me and I explained why.
I created a folder called 'Legislation Training' and used Rules Wizard to divert any email received with the subject line: 'Legislation Training Requirement' into the folder. Every time a new email arrived it automatically went into the folder and Outlook incremented and displayed the number of unopened emails in the folder in brackets at the end of the folder name. It looked like this: 'Legislation Training (125)'.
By the deadline all I had to do was look at the end of the Legislation Training folder to see how many people needed the training. No counting ... all done automatically by our productivity tool Outlook 2002.
As the fast talking salesman on the television said, 'And there's more!'
When I was asked for a list of the names of those who had responded, all I had to do was export the Legislation Training folder emails to MS Excel. Excel allows you to choose the fields you export. I chose the 'From' field and finished up with a list of names since all email addresses were in the format WILLIAMS Royston. Once in Excel it was a simple matter to sort them into alphabetical order.
Not only that, I could now email 20 people at a time and advise them when and where they had to attend this mandatory training.
This is an excellent way to deal with large numbers of people and, although Outlook does have options for creating forms with yes/no buttons and so on in them, it is more complex than this option.
I hope this short article has been of interest to you and that it helps you improve your work performance.
Robin Henry is a human resources specialist who provides support to small businesses keen to improve organisation and methods. He operates his home-based business from Central Australia and his site is found here http://www.dwave.com.au
This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news
Google Pixel 3 seems to have a memory management issue which kills background apps, affects camera - 9to5Google
Effective Strategies for Driving Multifamily ROI Growth through Property Management - National Real Estate Investor
Lightbend Releases Enterprise Suite 2.0 For Run-Time Monitoring and Management of Reactive Applications - Associated Press (press release) (blog)
Allowing Employees Responsibility
Merely assigning a task with detailed instructions is not effective delegation. An employee cannot grow without the freedom to make decisions on how the job should be done.
The "Better Product" fallacy
Another fallacy ingrained in the minds of most marketing managers is the belief that the better product will win the marketing battle.Behind the thinking of many marketing managers is the thought that "truth will out.
Are You Cascading Your Strategy, or Fragmenting It?
INTRODUCTIONThe typical approach executive teams use to cascade, or roll out, their strategic direction is to produce a clear set of goals, objectives, critical success factors or a scorecard and then get each departmental or functional manager to take this on board and customize it for their part of the organisation. The trouble then begins?A TYPICAL APPROACH: EACH DEPARTMENT ADOPTS OR ADAPTS A VERSION OF THE CORPORATE STRATEGYThe first phase of most organisational planning processes is that the organisation's executives design and express a strategic direction using a framework of some kind.
Creating a Team Working Environment
TEAM DECISION MAKING: Managers who invite participation believe that people directly affected by a decision should be involved in making that decision. The effort is toward joint, cooperative decision making.
Interviewing Applicants Can Be Hazardous to Your Wealth
1st Fact: Interviewing applicants is the most common way companies decide whom to hire.2nd Fact: Research proves most interviewers do lousy at predicting if an applicant will succeed - or flop - if hired.
How To Conduct Effective Meetings
Before you call your next meeting, the FIRST step is to decide if it is really essential. To determine that, ask yourself the following:· Is this meeting essential? · Can we do without it? · Can we accomplish the task without a meeting? · Can it wait another week? · Can we get things done with few meetings?Then, if you have decided a meeting is the best way to accomplish your objective, the following tips can help you conduct more effective meetings:1.
What is Six Sigma?
Six Sigma is a highly disciplined process focused on satisfying customers by delivering nearly perfect products and services. In today's competitive market, consistently maintaining satisfied customers is essential to growth and success.
Do Customers Like the Feel of Your Organization?
In two recent articles "Some Evidence of How We Are Spiritually Connected" and "Healing Dysfunctional Families" I reported on how individuals who live or work within a system or group are inherently connected at a level that goes beyond words. This realm of connection, which is largely spiritual or unconscious, may or may not be familiar to the more business minded person so I will take some time to explain the nature of this connection and then the wide reaching implications this idea has on the optimal functioning of organizations.
Outsourcing Problem Analysis
As an HR professional, you have responsibilities in several broad areas that have a significant impact on your company's bottom line, directly contributing to the corporate return on investment. The outsourcing choices you make are critical decision points that affect both your employer and the HR community at large.
Why All Managers Are Alike
Because, like you I suspect, they have key target audiences whose behaviors help or hinder them in achieving their organizational objectives.But even in their own best interests, too few involve themselves in their public relations effort to the degree they should.
Are You Measuring Something Meaningful?
Avoiding inert measures that anaesthetise your performance management.INTRODUCTIONYou sit before the monthly report, which might be an inch or so thick, and you contemplate whether it's the best use of your time to paw through the pages to check if there's anything useful in there for you.
Score the Rainbows Pot of Gold: Become the Boss That No One Wants to Leave
Leadership is lifting a person's vision to higher sights, the raising of a person's performance to a higher standard, the building of a personality beyond its normal limitations. Peter DruckerLadies and gentlemen, the captain has turned on the seat belt sign.
How to Hire the Right People
One of the biggest challenges any business owner or manager has is hiring the right people. I've recently discovered a simple, inexpensive yet very effective way which will help you get it right.
Creativity and Innovation Management - Feasibility
Creativity can be defined as problem identification and idea generation whilst innovation can be defined as idea selection, development and commercialisation.There are other useful definitions in this field, for example, creativity can be defined as consisting of a number of ideas, a number of diverse ideas and a number of novel ideas.
Are Your Marketing Pieces Up to Date?
The other day someone asked me for one of my informational brochures. As I was giving her the piece I stated that if I were printing these today it would be a little different.
Minimising Conflict With Effective Communication
Did you know there are 5 types of communication that lead to conflict? Let's look at them..
How To Write Commercial Collections Letters
It is sometimes valuable to bring the sales manager into this step of the collection process. Information concerning the delinquency can often be obtained from the sales department.
Knowledge Management: More Than Just Know-how!
People sometimes interchange the terms "know-how" and "knowledge", but there's a world of difference! Systems vendors are falling over themselves to sell you so-called "integrated knowledge management solutions", but these are rarely more than glorified information management systems with go-faster stripes.If we fail to understand knowledge in all its facets, then there is a danger that in doing so we miss out on the most valuable aspects of knowledge management and end up delivering a system-driven solution, rather than a cultural shift towards sharing and learning from experience.
Training Adults, Not Teaching Children
Adults are vulnerable to personal and professional embarrassment from poor performance in the training program. Poor performance in the classroom may become the basis for personnel decisions by supervisors or the source of ridicule by peers.
Improved Communication to Improve Results
Facilitating good communication can make the difference between a well oiled, effective team and disorganization and ambiguity. By following the tips below, you, the supervisor, can take steps toward improving communication with your employees:1.
|home | site map|