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

Future Business Success - What Does Good Look Like?

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

Project Management - Are You Done Yet

What happens when a Project Manager asks one of his... Read More

Problem Solving - Think Cleopatras Ass

Picture the scene. Anthony pops down to the guardhouse, partly... Read More

Why Would Anyone Hold a Bad Meeting?

Pssst, want a stock tip that will make you rich?... Read More

Towards Intercultural Understanding

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

Finding Proactive Solutions: A Key to Demonstrating Your Management Fitness

In my book Talking Points: 25 Tips for Clear, Credible... Read More

What Every Manager Should Know About How to Reduce the High Cost of Employee Absenteeism

Employers pay a high price for absenteeism, often more than... Read More

Survival of the Fittest: The Road to Human Extinction

I was watching a TV program some months ago about... Read More

Managing Change - Get it Right

In any event, getting the process right is a vital... Read More

Creativity and Innovation Management ? Feasibility

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

Delegation - The Basic Steps To Reducing Your Workload And Creating A Successful Team

If you have a task greater than you can handle... Read More

Employee Discipline: How to Nip Problems in the Bud

Are you uncomfortable with delivering disciplinary action, even involving employees... Read More

Coaching Champions at Work

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

Are You Measuring Something Meaningful?

Avoiding inert measures that anaesthetise your performance management.INTRODUCTIONYou sit before... Read More

From Boring to Interesting - Making Training Effective

Being a good trainer requires experience and skill. Experience comes... Read More

CEOs Role in Family Business

I first met Roland (not his real name) in 1972.... Read More

On The Job Training is Something You Canâ??t Afford to Skip

Trained employees are more productive employees; thereâ??s no doubt about... Read More

The Ins and Outs of Internal and External Relations

INTERNAL PUBLIC RELATIONS: Never overlook an opportunity to do internal... Read More

Collections Management

How long does it take your customers, clients or patients... Read More

Auditing Improves Effective Planning

Speak of operations assessment, and we'll hear its significant value.... Read More

Spirits in the Corporate Boardroom.......Oh, sure......

There is a growing movement in the spiritual... 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 :- Thought Leadership

Leadership is only sustainable when leaders consistently come up with... Read More

What Your Employees Want You to Know (But You Might Be Afraid to Ask)

This is a challenge for every company owner and manager.... Read More

Develop Your Managers and Keep Your Staff

Following on from the last edition of The Organised Times... Read More