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

---

Performance Appraisals: Nightmares or Sweet Dreams

Some managers think of performance appraisal meetings and recollections of... Read More

What Every HR Manager Should Know About Hiring Productive Employees

The characteristics of job applicants have a strong influence on... Read More

Importance of Just-In-Time Inventory System

In today's competitive world shorter product life cycles, customers rapid... Read More

Tales From the Corporate Frontlines: An Unexpected Benefit

This article relates to the Compensation and Benefits competency, commonly... Read More

Business Fails When We Do Not Talk

You may remember being told as a child, "Keep quiet!"... Read More

10 Resolutions For The New Year!!

Each year many people create a list of resolutions designed... Read More

Vampire Meetings and How To Slay Them

Meetings can be like mythical vampires ? sucking the life... Read More

Islam in the Workplace

Suggested practice for HR personnelMuslims now form one of the... Read More

Qualities of a Great Manager

In the call center environment we are often only as... Read More

The Ivory Tower Syndrome

"His cardinal mistake is that he isolates himself, and allows... Read More

Its a Training Issue!

There's a common phrase used by Organizational Development and Human... Read More

Tales from the Corporate Frontlines: Providing Career Opportunity

This article relates to the Career Opportunity competency, commonly evaluated... Read More

Middle-Aged Managers, the Forgotten Digital Divide

The digital divide is defined by the role computers play... Read More

Dont Wait for Tax Time to Look at the Bottom Line

A curious thing happens to entrepreneurs in the spring of... Read More

What is Knowledge Management Anyway?

When you think of all the things companies have, you... Read More

The Measurement of Manager Training

THE MEASUREMENT OF TRAINING: Evaluation is one of the most... Read More

Motivation - You Get What You Reward

There's a programme currently running on BBC Television in the... Read More

ISO 9001 and Total Quality Management

Total Quality ManagementTotal Quality Management, or TQM, has become one... Read More

Creativity and Innovation Management ? Feasibility

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

Hire Winners: Avoid These 10 Interview No-No?s

Have you ever hired someone who did not live up... Read More

Can Your Corporate Policy Pass the Monkeys, Bananas, and Water-spray Experiment?

Five monkeys were placed in a cage. A banana was... Read More

Counseling Interviews for the Marginal Employee

ACTIVE LISTENING: The most frequent cause of failure in therapeutic... Read More

Get Down With OCP: Evaluating DBA Job Applicants in an OCP World

Not long ago, weeding through DBA applicants with a tech... Read More

Five Steps to Successful Business Succession

The great majority of family businesses in North America are... Read More

Outsourcing Quiz: Cheap Vs. Good

Someone can say, 'Why do you oppose this?' So I'd... Read More

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... Read More

Meeting Your Meeting Expectations

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

Why Do Managers Create Low Morale? Or Does My Bum Look Big In This?

Why do managers create low morale as a product of... Read More

Agendas Make Meetings Productive

Having an agenda template that works well for you, week... Read More

Overcoming the Document Tracking Challenge

"Where did it go? It was here yesterday. Wait. Here... Read More

Entitlement Programs Kill Productivity

In articles I've written over the years, I have used... Read More

Getting to Consensus

The need to get people in an organization to pull... Read More

Results of Poor Cross Cultural Awareness

Results of Poor Cross Cultural Awareness. Having a poor understanding... Read More