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

---

Time Management Tips for Managers

Late last year I was presenting a workshop for the senior managers of a major organisation. Whilst doing a pre-workshop survey to assess the challenges these managers... Read More

Why Your Company Needs An E-Mail Policy

Everyone at the office thought that using the company e-mail system to share jokes and funny stories was great fun. That is, until one offended employee decided... Read More

Innovation Management ? Flexibility

Creativity can be defined as problem identification and idea generation whilst innovation can be defined as idea selection, development and commercialisation.There are other useful definitions in this... Read More

Vampire Meetings and How To Slay Them

Meetings can be like mythical vampires ? sucking the life out of intelligent and creative people. And sucking the funds out of businesses. Unfortunately, there are too... Read More

Contract Management Software: the Solution to the Problem of Coordination

Charles Petrie, from Stanford, released a short article entitled "The Problem of Coordination," which highlights 4 categories in which businesses find it difficult to connect:InteroperabilityAgent Communication... 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 things.A common measurement trap is to measure something because it's "interesting." If... Read More

What Is Business Sense?

What is the principal thing you need to succeed in your business today? Money. Sure, you need it, but it is not the main ingredient for success.... Read More

Creativity and Innovation Management: The Creative State

Creativity can be defined as problem identification and idea generation whilst innovation can be defined as idea selection, development and commercialisation.There are other useful definitions in this... Read More

7 Tips for Growing Your Business You Do Not Want to Ignore: Business Strategies To Easily Implement

Growing companies must always be ready for the next challenge. If you fail in meeting critical business challenges you will not grow. Challenges often require some type... Read More

Getting to Consensus

The need to get people in an organization to pull together comes out often in discussions about communication.Let's think of it as getting to consensus, to roll... Read More

Middle Managers Behaving Badly ? How To Stop This Damaging Your Results

More and more I hear and read about a looming crisis of leadership at the middle management level and the inevitable resulting increase in, poor performance, accidents... Read More

Lead to Succeed: The Seven Essential Steps to Work Leader Success

In my book "You're In Charge?What Now?" I use a mnemonic to describe the seven essential steps to work leader success. The mnemonic is "L.E.A.D.E.R.S" and each... Read More

Joint Accountability: Another Key for Your Effectiveness

I once was part of a group of management professors who often taught in executive development seminars. Other non-management professors in the school ran these. Occasionally these... Read More

5 Steps to Continuous Process Improvement

Part One of Creating Well-Defined Processes SeriesWhat if your sales increased from $100,000 to $110,000 per day and your profit increased from $10,000 to $11,000 ? did... Read More

Proven Secrets to Keeping Your People and Increasing Your Profits

Why are people changing jobs so quickly these days?Here are a few reasons why:They have a boring job therefore they feel they are not achieving anything.They have... Read More

CEO: The Key To Fix ingThe Marketing/Sales Collaboration Problem

We all know that achieving better alignment, synergy and cooperation between company marketing and sales departments is vital, but oh so elusive. Despite all the talk and... Read More

Human Resources: The Misidentified Subject

Interest in the field of human resources has exploded in recent years due to the promises it offers for a better understanding of human beings at work.... Read More

Re-Discovery Procedures for Building Effective Management Systems: Phase V

Now we turn the corner to our final phase: Re-Discovery.Last year marked the 200th anniversary of the expedition of Lewis & Clark, and much has been written... Read More

Organizational Structure, Creativity, Innovation

Organizational structure can inhibit or foster creativity and innovation. The problem with organizational structure though, is that it is resultant of many factors, including history, organic growth,... Read More

Involving People Gave Us the Improvements We Needed

We had a problem with handling materials in a production department. Our process required raw materials to enter the department, be processed, and leave the department. The... Read More

Managing Group Meetings

MANAGING SMALL MEETINGS: Keep the size of the meeting as small as possible. The larger the group, the more complicated communication becomes and the more garbled the... Read More

Uncommon Common Sense ? Know What is the Most Important Thing in Your Business

Over 3 of my meetings with 3 business owners last week, what really shocked me was how uncommon common sense was. 2 out of 3 I spoke... Read More

Management to the Vision-Contribution and the Role of Compliance

As a manager our role is to:1. Establish the vision, or our contribution to the vision.2. Establish the plan and forecast for our management contribution, be it... Read More

Turbo-Charge Your Rollout with ERM

Employees are the often-neglected stakeholders in the success or failure of a CRM (Customer Relationship Management) initiative. But employees don't always resist new ways of doing business.... Read More

Five Ways to Turn Resistance into Opportunity

Resistance. It isn't something people cherish or enjoy encountering. We experience resistance everywhere at work:People don't like that idea.People don't want the work flow to change.Someone doesn't... Read More

Drafting an Employee Manual Sample Outline

One of the hardest things I had discovered running my company was drafting an Employee Manual. Also added to the stress was the fact that if you... Read More