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

The Significance of the Mundane

This article begins with a tip of the hat to a scholarly publication called the... Read More

Resolve Differences

Resolving conflict doesn't come easily to too many people. Most of us want harmonious relationships... Read More

The Top 5 Signals That Your Business Is Running You

Starting your own business is a great undertaking but running the day-to-day aspects of your... Read More

Preparing a Budget

Ok, you say, I know I need a budget, but how do I prepare one?... Read More

Policy & Procedure Manuals - Tools For Greater Productivity and Efficiency

In today's tough retail environment the retailer needs all the tools he can get to... Read More

You Cant Afford the Luxury of Disengaged Employees

In today's business environment with increases in staff reductions and rapidly changing roles and responsibilities,... Read More

What Cross-cultural Training Can Do for You

International business is more complex than ever before. Success in every sector is now seen... Read More

Employee Motivation: It?s More Than A Paycheck

Managers often ask, usually with exasperation, "How can I keep my employees motivated? I pay... Read More

Real Costs in Distribution and What it Means To Your Company

Ever feel that all the lawyers in thh Country need to give their lives up... Read More

Employee Orientation: Get New Hires Off To a Great Start

The good news is that a new hire orientation program offers an opportunity to build... Read More

Problem Solving - Think Cleopatras Ass

Picture the scene. Anthony pops down to the guardhouse, partly because he wants a break... Read More

Counseling Interviews for the Marginal Employee

ACTIVE LISTENING: The most frequent cause of failure in therapeutic counseling interviews is the interviewer's... Read More

Setting a Pitiful Example: Twenty-six Warnings to Heed *

TO: All Parents [and Employers and Managers]From: Your Child and/or EmployeeDate: The present timeRe: Don't... Read More

Preventative Maintenance of Company Delivery Vehicles

If you have company delivery vehicles at your small or medium sized business you should... Read More

Regaining Control - Nine Steps for New Managers

My client had faced the same challenge, which was frustrating as well as intimidating for... Read More

Coaching Employees in the Workplace

After a full week of training, you are still a little nervous about your new... Read More

How Managers Can Help Retain Their Best Employees

A major problem for employers today is attracting the best talent, and then retaining key... Read More

The Seven Cs: Partnership Danger Signs - The 5th C: Control Issues

A series of articles exploring the seven critical areas that can indicate a partnership is... Read More

Innovation Management ? the Root of the Problem

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

Management Team Section of Business Plans

Writing an award winning business plan is a great skill, but rather than winning any... Read More

Creativity and Innovation Management ? Hierarchies

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

Character: Is It Necessary In Leadership? (Part Two)

In the first part of this two part article, I talked about the importance of... Read More

Managing the Human Resource Project

We obtain strategic results by aligning HR mission, vision and values. The following overview highlights... Read More

Improving Patient Sensitivity in Doctors and Hospital Staff

COMPANY/ORGANIZATIONA South Florida hospital. The CEO of the hospital saw the need to provide exceptional... Read More

The Idol-Makers

The end of the television season in May included the usual array of cliffhangers on... Read More

Manage or Lead ? Why the Difference Matters and What to Do About That Difference

Many books have been written about managing people, and an equally large... Read More

Management Training: Are You Satisfied With The Results?

If you're not satfied with the results of your management training programs, maybe it's because... Read More

To Meet or Not to Meet - What are the Questions?

Meetings can be a total waste of time or a powerful and productive communication tool... Read More

The Professor Makes A Minus Power Move

If you think the power move has costs, consider the alternative. We are talking --... Read More

Knowledge Management - Learning Whilst Doing - Facilitating an After Action Review

Introducing a learning culture into organisations can be difficult at times, particularly if the effort... Read More

Innovation Management ? how will we make the go or kill decisions?

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

Employees - Treat Them the Way They Expect to be Treated

When you have to deal with one of your team who's complaining to you, rather... Read More

Leadership Styles - the Ten Top Qualities the Best Leaders Show

Top leaders...Are Visionary Top leaders have a very clear understanding of where the organisation is... Read More

Improvements In A Large Public Electric Utility In South America

The company decided to develop and implement an improvement program. The main thrust was to... Read More

Executive Humor at Meetings

I don't encourage managers to wear funny hats, appear in self-deprecating skits, or otherwise emulate... 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 raising of a person's performance... Read More

Productivity Through Positive Reinforcement

Most people just want to be appreciated. If you're a manager, that's something to seriously... Read More

Creating Your Own Business Upturn - Powering Business Development

We all see it . . . business markets are trying hard but continue to... Read More

Turnover is Not a Problem

"Ha!" you say. "For someone to make a statement like that, they obviously haven't worked... Read More

When Business Becomes A Battlefield

"We have to be careful it's like a minefield out there" "I like to lob... Read More

The Red Phone - Management Consulting in 30 Seconds or Less

Modern business faces complex problems; management often calls upon highly-specialized consultants to help them address... 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 to leave your team or... Read More

Protect Your Organizations Proprietary Information

The other day one of our overseas clients called in a state of near panic,... Read More

Top Ten Tips for Outstanding Customer Service

Remember the 80:20 rule? You may not get everything perfectly right, but getting most right... Read More

The Four Key Steps In Hiring And Keeping Top People

"When you hire the best, the rest is easy!" We have heard this phrase many... Read More

Creativity Management ? Quality from Quantity

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

The Challenges of Human Resource Management

IntroductionThe role of the Human Resource Manager is evolving with the change in competitive market... Read More

Driving of work trucks

Each time you or one of your work crews cruises down the road, people see... Read More

Are Your Marketing Pieces Up to Date?

The other day someone asked me for one of my informational brochures. As I was... Read More

Getting Your Employees Attention Back to Work

It is 9:00 am on a Monday morning. Do you know where your employees' attention... Read More