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

Innovation Management: The Quality and Quantity of the Idea Pool

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

Quality Staffing: Stop Placing the Wrong People in the Wrong Jobs

You can possibly teach a turkey to climb a tree ? but it is a... Read More

A Journey of a Thousand Miles

You can't build a reputation on what you are "going" to do. Henry Ford Everyone... Read More

How to Attract and Retain the Right People

If you're one of the many executives struggling with finding and keeping the right people... Read More

Innovation Management ? Rigorous data analysis

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

Three Business Lessons From The US Postal Service

There was a buzz in the air recently about the US Postal Service. Seems as... Read More

Another Use for Meetings

Every meeting is a laboratory where you can observe and learn important things about the... Read More

Dont Let Your Measurements Mislead You

Don't Let Your Measurements Mislead You There aren't too many words... Read More

Try It Out On Your Team First

Wow! You're brilliant! You have a great idea. You've looked at it every possible way... Read More

Resolve Differences

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

The Dog That Didnt Bark

A few weeks ago, after consultations with others in an association I represent, I made... Read More

Why Free Agent Thinking Is Good For Your Company

It's no secret! Day after day the news is riddled with companies who are moving... Read More

Is It Worth To Outsource? How One Can Outsource Wisely

Recent trends in software development market show that it is no longer the most efficient... Read More

Great Employees = Passionate Consumers

Companies spend millions of dollars each year identifying their brand, and then communicating their brand... Read More

Problem Solving

When problem solving, you may recognize that you were working on a symptom instead of... Read More

Experiences of Management Coaching (Part 2)

In our experience, we have found that there are several reasons managers fail to get... Read More

Business Intelligence & Data Warehousing in a Business Perspective

Business IntelligenceBusiness Intelligence has become a very important activity in the business arena irrespective of... Read More

Coaching Champions at Work

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

First Things First -- Process BEFORE Technology

Here's a brief story I encountered while leaving Newark International Airport following a recent business... Read More

Cheat Sheet; Understanding The MSDS and Your Obligations In The Workplace To Employees

MSDS SHEETSMSDS stands for Material Safety Data Sheets. MSDS sheets contain nine sections. These sections... Read More

Avoiding The Sheep Dip

It is a sad fact that many employees are still being subjected to the age... 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

How To Prevent Your New Manager From Becoming A Statistic

According to a study by the Manchester Group, 4 out of 10 new managers fail... Read More

1000 Managers Turned Their Plans Into Energy!

I bet you can't tell me how leadership training and strategic planning work together to... Read More

Innovation Management ? does the idea fit with the firm?

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

Problem-Solving Success Tip: Look For Sponsors And Solution Owners

Look for sponsors and solution owners rather than problem owners.Everyone participating in the situation owns... Read More

ISO 9001 the Process Approach to Quality Assurance

What is the Process Approach to Quality?The ISO 9001 2000 standard is designed to manage... Read More

The Inferno of the Finance Director

Sometimes, I harbour a suspicion that Dante was a Financial Director. His famous work, "The... Read More

Online Business Peace of Mind

Is your online business disaster-proof? Online businesses face a unique set of challenges. Unlike our... Read More

Knowledge Management - Lessons Learned and How To Identify Them

Many organisations use the term "lessons learned" to describe the way in which they avoid... Read More

Develop Your People and Make More Money

What is the no. 1 asset in your business beside yourself? It's your people.Then why... Read More

Managing Meetings

Plan/prepare - lack of purpose causes aimless meetings. Know why you're there - what the... Read More

Finding the Right Way to Motivate Your Employees

Fear, Incentives and GrowthZig Ziglar says that there are three main ways to motivate people... Read More

Office Politics

Office politics! It's just another way of saying: "The employees are not getting along!"When so... Read More

Are You At The Mercy Of Computer Geeks?

Many business owners are sabotaging their business without even realizing it. They are completely out... Read More

Developing Your Management Style

One thing a lot of us don't do in sales is take time out to... Read More

Which ITIL Process Should We Implement First?

The following question is usually debated a lot amongst IT managers. "With which process should... Read More

Recruitment - Do You Know What Youre Looking For?

The time will come when you'll need to interview someone to join your business or... Read More

What to Do When Trust is Low

Trust is essential. You can't run a business without it. Customers leave. Risk taking evaporates.... Read More

Problem Solving the Problem Solving Meeting

We go to meetings to share information, to report on project status, to make decisions,... Read More

Problem-Solving Success Tip: Dont Leave Your Key Stakeholders Guessing

Communicate! Don't leave you key stakeholders guessing.We are generally not very good about keeping others... Read More

Top Ten Things About Creating a Business Vision

To visualise where you are going, is deeper and more sensory than anything you have... Read More

Five Key Strategies for Making Your Nonprofit Business More Effective

I love tennis both as a spectator and a weekend player. I also... Read More

Business Fails When We Do Not Talk

You may remember being told as a child, "Keep quiet!" "Children should be seen, not... Read More

Creating a Team Working Environment

TEAM DECISION MAKING: Managers who invite participation believe that people directly affected by a decision... Read More

The Top Three Problems IT Managers Face and How to Overcome Them

Todays business environment has changed drastically from just a few years back. Rather than working... Read More

When Code Freeze Turns To Code Slush

Time To Market (TTM) is a vital concept that every executive understands. Releasing a product... Read More

Problem-Solving Success Tip: Measure the Right Things.

Measure the right things. It's not enough just to measure-you have to measure the right... Read More

Radical Creativity from Incremental Creativity ? large movements from small changes

Positive radical movement is the holy grail of nearly every decision maker. Every CEO wants... Read More

Truth or Consequences: How to Give Employee Feedback

In the bestseller, Good to Great, Jim Collins discovered that, "the good-to-great companies continually refined... Read More