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

---

Warning! Meeting In Progress; May Be Hazardous To Your Career

There ought to be a sign posted on every closed... Read More

Indecent Proposal in the Workplace ? An Overview of Workplace Harassment & Employer Liability

An allegation of harassment in the workplace is a growing... Read More

The Seven Cs: Partnership Danger Signs - The 5th C: Control Issues

A series of articles exploring the seven critical areas that... Read More

Innovation Management ? does the idea fit with the firm?

Creativity can be defined as problem identification and idea generation... Read More

Innovation Management ? Flexibility

Creativity can be defined as problem identification and idea generation... Read More

Learn to Assert Yourself

Pinpoint your own blocks to assertiveness: fear of disapproval, need... Read More

How to Approach Group Decision Making

GROUP DECISION MAKING -- IDENTIFY THE PROBLEM: Tell specifically what... Read More

Creative and Innovative Culture, Change Management ? Three Easy Tests

Creativity can be defined as problem identification and idea generation... Read More

Interviewing Candidates: 3 Ways to Avoid Snap Judgments

Have you ever hired the wrong person? If so, perhaps... Read More

Protect Your Computer System with a Comprehensive Security Policy

The most difficult part of creating a Security Policy for... Read More

Business Innovation ? Organizational Culture

Creativity can be defined as problem identification and idea generation... Read More

The Most Important Thing Youll Ever Do

The wellspring of confidence is belief. When you believe in... Read More

Performance Appraisal Checklist: Raise Not Just Appraise Performance

It's that time again! Perhaps the most dreaded management practice... Read More

ISO 9001 2000, Getting Started on The Route To Registration

ISO 9001 2000, Getting startedBefore starting the ISO 9001 2000... Read More

Sarbanes-Oxley and Section 404: Old Dog, New Teeth

The failures we have seen in the quality and integrity... Read More

Phone Sex is Bad for Business

On August 3rd/2005, Reuters reported that a German man had... Read More

Partnering for Performance

"The difference between a boss and a leader: a boss... Read More

Presenteeism: The Hidden Costs of Business

(prez.un.TEE.iz.um) nPresenteeism, a relatively unknown concept, is the complement of... Read More

Leaders Versus Cheerleaders

Everyone wants to describe themselves as a leader. Everyday, new... Read More

ISO 9001, What Next?

The overriding goal of ISO-14000. (History 1995)As ISO-9000 becomes a... Read More

Designing Your Healthy Administration - A Management Overview

Management or Leadership?Simply stated, management ensures that things get done,... Read More

The Survey Feedback Process for Organizational Development and Change

THE PURPOSE OF SURVEY FEEDBACK:In globally competitive environments, organizations are... Read More

Biometrics and ?Return On Investment?

At this time of tight budgets, the mantra of business... Read More

How to Beat the Turf Mentality

Want to hear a fascinating story? Let's sit in at... Read More

Problem-Solving Success Tip: Look For Sponsors And Solution Owners

Look for sponsors and solution owners rather than problem owners.Everyone... Read More

Look Good on Voice Mail

Your use of voice mail tells others a lot about... Read More

Develop Your People and Make More Money

What is the no. 1 asset in your business beside... Read More

Customer Focus - Just 5 SimpleThings You Need to Think About

You can boil down the difference between successful businesses and... Read More

Tales From the Corporate Frontlines: Team Dynamics and Communication

This article relates to the Team Dynamics competency, which evaluates... Read More

Meeting Your Meeting Expectations

"To get something done a meeting should consist of no... Read More

Spotlight on Productivity: How to Overcome E-Mail Overload

Do you ever feel overwhelmed by e-mail? Have you ever... Read More

Never Hire Anyone Dumber Than You Are!

In a previous life I was a Navy Pilot. Great... Read More

Provisioning/User Management System Upgrades: Part I -- Ten Reasons Why Not To Do An Upgrade

Tommy Sherman daily monitors a helpdesk-provisioning queue for a large... Read More