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 Invisible Communication Barriers Kill Productivity

Many kinds of interferences or disturbances can confuse a message.... Read More

How to Delegate More Effectively

Do this simple excercise, and transform your life.First, Make a... Read More

Let the Intern Do It - Affordable Help for Your Business

Do you have more projects than time? Help might be... Read More

Why Management Kills Creativity

Ten or so years ago, an international consultant, specializing in... Read More

Morale Boosters: Feed the Troops First

When economic conditions turn tough or when the heavy work... Read More

What is Knowledge Management Anyway?

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

This Old Business

Not long ago I was asked to come out and... Read More

Catch Your Staff Doing Something Right

A long time ago, I learned something about being a... Read More

Allowing Employees Responsibility

Merely assigning a task with detailed instructions is not effective... Read More

Does My Bum Look Big in This?

If a good manager asks his workforce for their opinion... Read More

50 Great Ways to Motivate and Not Break the Bank

Quick, Easy, and Even Fun! 1. Smile, say "Hi! How... Read More

Conflict Resolution Training- When Personal Safety is an Issue

Conflict generally arises by having your needs, desires, perceptions and... Read More

Managing Employees Is A Little Like Herding Cats

Q: I started my small business about a year ago... Read More

Five Steps to Increase the People Power in Your Business

Take some bold steps and help your employees and business... Read More

Small Business Outsourcing: An Introduction

Outsourcing is the delegation of a business process to an... Read More

Oasis in a Cash Flow Desert - Four Resources That Increase Small Business Capital Streams

For small business owners, an enthusiastic vision for smooth, steady... Read More

Growing Profits is Easy!

Everyone involved in running a business from the smallest start-up... Read More

Successful Managing Through Delegation

Managers should avoid the tendency to constantly delegate to the... Read More

Travel the World - for Free!

I have been very fortunate to travel to several countries... Read More

HRM: Contributing to Well-being or Ill-being at Work?

If you were to take the people out of an... Read More

Its All In The Systems

Have you ever noticed french fries taste the same at... Read More

Keep The Faith - Transform The Fear

FEAR! To what extent does fear rule your life? How... Read More

Business Innovation ? Value versus Quality

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

Déjà Vu MCI to Qwest International Inc: Can this Corporate Marriage Survive?

Current Situation:As of this writing, the MCI Board of Governors... Read More

Must Project Managers Be Technically Savvy?

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

What Is Business Sense?

What is the principal thing you need to succeed in... Read More

Managers Who Spend PR $$ Wisely

If you are a department, division or subsidiary manager, your... Read More

3 Innovation Keys - Do Your Innovative Efforts Need More Power?

Recently, I attended a webinar with nearly 400 other Chief... Read More

Strategic Clarity for Communication Management

Over the past few weeks I've been developing plans for... Read More

Ten Steps to Take the Work out of Work ? Replicate Yourself!

They say that management can be a lonely place. A... Read More

Coaching Champions at Work

I saw Brian Kerr (the Irish national football coach) on... Read More

Selecting a Business Broker or Intermediary to Help You Sell Your Business

As crazy as it seems, some people spend more time... Read More