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

---

People - You Cant Make Them What Theyre Not

Many business people and managers are spending too much time... Read More

Be a Leader - The Importance of Going Home Early!

How you run your business is, of course your business.... Read More

Recruitment - Do You Know What Youre Looking For?

The time will come when you'll need to interview someone... Read More

IT Expenditure - Why Businesses Spend Huge Amounts on Ineffective IT Investments

Another IT White Elephant!It seems that almost every day we... Read More

Being a Great Boss

Are you one of those bosses that people just love... Read More

Interviewing Applicants Can Be Hazardous to Your Wealth

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

A Rare Leadership Skill: Dealing With People Who Want Out By Offering Crowns For Convoy

As a leader, you'll inevitably be faced with people wanting... Read More

Parenting Your Employees to Better Performance

Have you ever worked for someone who was such a... Read More

Give Yourself a Boss Day Gift, Part 2: Are You the Position or the Person?

Are you the position or the person?Bosses can lose their... Read More

Employee Motivation: It?s More Than A Paycheck

Managers often ask, usually with exasperation, "How can I keep... 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

Future Business Success - What Does Good Look Like?

When you know you need to shift up a gear,... Read More

How Managers Can Turn Failures Into Successes

Although there are real, external reasons for managerial difficulty ?... Read More

The Golden Key to Meeting Success

We all attend many meetings. I'm sure you have been... Read More

Todays Employees and Their New Needs: What You Need to Know

Today's employees are not only interested in security or in... Read More

Best Practices Plan: Dissemination of a Great Idea

Good news spreads quickly News of the invention of the... Read More

1000 Managers Turned Their Plans Into Energy!

I bet you can't tell me how leadership training and... Read More

A Winning Way to Handle New Ideas

Janet DiClaudio, who was charge of medical records at two... Read More

How to Leverage Your Strengths for Peak Performance

Ask almost any business leader how to most effectively develop... Read More

What is the Most Difficult Part of an Improvement Program?

Answer: Starting one.Most of us realize that there is probably... Read More

Creativity and Innovation Management: The Creative State

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

Innovation, Idea Selection, Valuation

There is no sure fire route to commercial success, but... Read More

Why Saying Well Done Works

Encouraged by the recognition, Sarah Lewsiton went home from work... Read More

How to Coach Your Emplyees and Increase Motivation

It is easy to spot the difference between a work... Read More

Coaching Champions at Work

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

Business Leadership Skills - Managing the Human Being Behind the Business

Managing the Human Being Behind the Business It's... Read More

Avoiding The Sheep Dip

It is a sad fact that many employees are still... Read More

Employee Retention: Five Leadership Fundamentals

Are your management practices on the right track? Retaining your... Read More

Four Employee Behaviors That Can Kill Your Business

I found it important to clarify for employees what "deal-breaker"... Read More

One Simple Idea to Grow Your Business

Perhaps the most common theme I've heard in working with... Read More

Sexual Harassment Policy Guidelines Part II

SEXUAL HARASSMENT COMPLAINT INVESTIGATION PROCEDUREEvery complaint will be thoroughly investigated.... 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

The Seven Cs: Partnership Danger Signs - The 4th C: Cumulative Money Problems

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