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 70% Solution: Practical Testing and Version Control

"What do you mean you need to push back the... Read More

Performance Expectations - 5 Tips and 5 Questions

People want to understand their role - they want to... Read More

Terrible Meetings - Ten Ways to Spot Them!

Sometimes, better than giving advice about how to run things... Read More

10 Critical Questions to Ask Before Hiring a Consultant

Talk to as many consultants as you can before hiring... Read More

10 Fundamentals for Effective Meeting

Here are ten fundamental concepts that characterize an effective meeting.Definition:... Read More

Small Business Checking Accounts

ACCOUNTING AND BILLINGCHECK BOOKSWe recommend that you maintain a business... Read More

Sarbanes Oxley 404 Compliance - How Nov. 15, 2004 Deadline Affects You

Fast Relief for Sarbanes Oxley Section 404 ComplianceSection 404 of... Read More

Business Innovation ? the Value of Work Processes

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

Quick Tips On Bringing Out The Best In People

Want to bring out the best in people?Edward W. Smith,... Read More

Making Assumptions - A Critical Communication Mistake In Business And In Your Personal Life!

We draw conclusions about people through observation, their behavior, past... Read More

Why Saying Well Done Works

Encouraged by the recognition, Sarah Lewsiton went home from work... Read More

Its a Training Issue!

There's a common phrase used by Organizational Development and Human... Read More

Tales from the Corporate Frontlines: The Role of Character in Leadership

This article relates to the Senior /Top Level Management competency,... Read More

Plans & Goal Setting - Kicking winning Goals

Kicking Winning Business Goals The competition for business... Read More

Compensation and Six Sigma Black Belts

One of the more ambiguous elements of a Six Sigma... Read More

Behavioral Interview Questions You Can Use Monday Morning

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

Out of Control?

There are papers on the floor, across the desk and... Read More

Improving Patient Sensitivity in Doctors and Hospital Staff

COMPANY/ORGANIZATIONA South Florida hospital. The CEO of the hospital saw... Read More

Why Training Fails

Sometimes when I conduct my workshop on Effective Meetings, one... Read More

Firing Someone Without Resentment

Firing, sacking, letting go or terminating people is unpleasant. There... Read More

Manage Your Business from the Rockies, not the Prairies

The day job as a manager is all about managing... Read More

Can Your Business Run Without You?

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

The Power of ?Ask?

For Call Center managers, it is not a pipe dream... Read More

Shrinkage Control

What has been your store's shrinkage experience for the last... 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... Read More

Outsourcing NOT Just for Big Business

Outsourcing has become a controversial issue and a hot topic... Read More

How to Make a Difference Every Day

Every day, everyone can make the world a better place.... Read More

Six Honest Business Friends - They Guide Me In All I Do

SIX "HONEST BUSINESS FRIENDS" - THEY GUIDE ME IN ALL... Read More

Innovation Management ? Innovation or Profit?

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

A Man and His Razor

It is vain to do with more what can be... Read More

Employees - Treat Them the Way They Expect to be Treated

When you have to deal with one of your team... Read More

Safety Policy Sample Outline

Writing a safety manual is a tough job and most... Read More

Recycling, Reverse Logistics and?..Candy

The candy box is a container for all your favourite... Read More