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

---

How To Delegate for Fun and Profit

Ah, the wretched pain of delegation. It comes easy to... Read More

Faith is the LIFE-blood of Your ACTIONS before the Benefit -

Nothing has changed. Your ancestors lived by faith. Some planted... Read More

10 Fundamentals for Effective Meeting

Here are ten fundamental concepts that characterize an effective meeting.Definition:... Read More

Its All About The Customers, Baby

If you want to ensure a steady stream of customers... Read More

Must Project Managers Be Technically Savvy?

"Must Project Managers be technically savvy?" This topic always seems... Read More

What 80% of Businesses Don?t Know: Tips for Improving Your Working Capital Management

What is the number one way to prevent failure in... Read More

The Paradox of Job Enrichment

Ellen was a clerk working for a large insurance company.... Read More

Why Employee Satisfaction Surveys And Employee Exit Surveys Make Good Sense

In a competitive world with the need for businesses to... Read More

Employee Success! - 7 Ways Feedback Works

By sharing how well you are doing and how well... Read More

Is It Worth To Outsource? How One Can Outsource Wisely

Recent trends in software development market show that it is... Read More

Lower the Bar

"Nothing great was ever achieved without enthusiasm." Ralph Waldo EmersonI'm... Read More

Innovation Management ? Diversity Can Make All The Difference

Companies are welcoming a diverse range of employees (The Sunday... Read More

Can Your Business Run Without You?

If you are a business owner or a business owner... Read More

Creativity and Innovation Management: The Value Of Due Diligence

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

Boost Your Leadership Skills Simply By Answering The Question, What Does Our Organization Really...

The difference between leaders is ears. Good leaders not only... Read More

Towards Intercultural Understanding

An individual's ability to forge effective relationships across cultures is... Read More

What to Do When Trust is Low

Trust is essential. You can't run a business without it.... Read More

Managing Dickheads

"We are so different and individualistic that we can't work... Read More

The Ten Keys to Maximizing Employee Performance

1. Let people know what you expect. If people know... Read More

7 Essential Elements To Every Organizational Change

[This article is based on excerpts from the special report... Read More

Tales from the Corporate Frontlines: Training is in the Eye of the Beholder

This article relates to the Training competency, commonly evaluated in... Read More

Another Use for Meetings

Every meeting is a laboratory where you can observe and... Read More

Business Innovation ? Status Games

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

Business Innovation ? Core Competency and Competitive Advantage

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

Six Sigma Training 101 ? Better Management Basics

What is Six Sigma?Six Sigma is a quality management program... Read More

Four Ways To Make the Case For Outsourcing

How do you convert outsourcing leads into clients? You may... Read More

Quality Improvement is Free

The point of a quality improvement program should not only... Read More

Supplier Sees 53% Reduction in Out-of-Spec Orders Case Study

The goal of perfection is a challenge. It is often... Read More

4 Steps to Success In Life, Business, The Universe And Everything

Everyone wants to succeed in life. And no one starts... Read More

Build Rapport Fast! - Eight Easy Steps

Building rapport is all about creating a relationship, in the... Read More

Interviewing Applicants Can Be Hazardous to Your Wealth

1st Fact: Interviewing applicants is the most common way companies... Read More

Hiring Your First Business Personal Assistant: Some Guidelines for Successful Hiring

Hiring the first personal business assistant is an exciting time... Read More

Recruitment - Pick People Who Think

Old style management doesn't encourage personal mind control, employees aren't... Read More