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

---

Paretos Law- Your Formula For Success

A 'dirt-world' retail business I used to manage had a... Read More

Is Your Management Style Assisting or Hurting Your Business?

Many times business owners can have significant differences in management... Read More

Learn About Commercial Collections Agencies Fees

As with any other service, there are good and bad... Read More

Turning a Negative Employee Into a Positive Asset

Several years ago, I took over the supervision of a... Read More

6 Steps to Effective Communication

Effective leaders are known for being excellent communicators. Here's what... Read More

Data Delivers Credibility

Over the past couple of days I've been setting up... Read More

Managers? Biggest Blunders

Nobody's perfect, including the boss. Managers, we polled recently, acknowledged... Read More

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

TO: All Parents [and Employers and Managers]From: Your Child and/or... Read More

Behavioral Interview Questions You Can Use Monday Morning

If past behavior is the best way to determine future... Read More

Managing Meetings

Plan/prepare - lack of purpose causes aimless meetings. Know why... Read More

Can Your Business Run Without You?

If you are a business owner or a business owner... Read More

How To Get What You Really Want

As a small business owner, entrepreneur or independent professional, it's... Read More

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

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

Tales from the Corporate Frontlines: Coworker and Caretaker

This article relates to the Coworkers competency, commonly evaluated in... Read More

Lets Flourish and Prosper!

Some say that in business as in sex: if it... Read More

Stomp Out Leeches In Your Company

Recently, I felt appalled to see a political candidate running... Read More

He Hate Me: Turning Their Bad Attitude Into Your Great Results

"He Hate Me" was the nickname of Rod Smart, a... Read More

6 Simple Steps to Dealing with Difficult Managers

The challenge of managing difficult managers can be rather daunting,... Read More

Middle-Aged Managers, the Forgotten Digital Divide

The digital divide is defined by the role computers play... Read More

Internal Prisons: The Thief of Productivity and Quality in our Workforce

As a professional speaker, one of my biggest challenges is... Read More

People Skills: Eight Essential People Skills

Being able to communicate effectively with others requires people skills,... Read More

The Communications Myth

Living in the 21st Century is truly marvelous, isn't it?... Read More

Bringing Ideas to Life: Seven Principles for Pulling Together

You're so excited you're practically bouncing off the walls. This... Read More

The Death Spiral

Sometimes things just happen. Maybe we lose focus and take... Read More

Top Ten Tips for Outstanding Customer Service

Remember the 80:20 rule? You may not get everything perfectly... Read More

The Top 10 Requirements for Your Business to Become and Remain Profitable

We live in a relentlessly competitive world. The daily pressure... Read More

Its Not Always What You Say

A major source of communication breakdowns is incongruence between the... Read More

Top 10 Things NOT To Tell Angel and VC Investors

I am not writing this to create a list of... Read More

Sarbanes-Oxley and Section 404: Old Dog, New Teeth

The failures we have seen in the quality and integrity... Read More

5 Ideas To Leverage The 3 Stages Of Career Development In Your Organization

In most industrialized nations, the average age a student graduates... Read More

The 10 Realities of Change

I've seen several articles that begin with lines like "the... Read More

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

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

Why Businesses Need to Start Nurturing Collective Wisdom

COLLECTIVE WISDOM CAN BE AN effective tool for solving the... Read More