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

---

Three Professional Services Resolutions for 2005

With client expectations higher than ever before, and the gradual... Read More

10 Steps Towards A Stress-Free Introduction Into Management

Becoming a manager for the first time can be an... Read More

Creativity and Innovation Management ? Idea Progression

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

How to Delegate Effectively

ACCOUNTABILITY: Delegation is not complete unless subordinates are held accountable... Read More

5 Tips For Creating Great Jobs

1) Create A Powerful "Mission Statement"-When your business mission is... Read More

Create Your Dashboard for Success

Driving down the road our eyes frequently scan the vital... 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

Close the Performance Gap

One of the most difficult and emotionally draining situations you... Read More

The Seven Cs: Partnership Danger Signs - Conflict Becoming the Norm ? Part 2

A series of articles exploring the seven critical areas that... Read More

The Diamond Cutter

Geshe Michael Roach is a Princeton graduate and a Buddhist... Read More

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

Todays business environment has changed drastically from just a few... Read More

Creating Advisory Boards

There is no substitute for soliciting the opinions of the... Read More

Make the Most of Your Time - Focus on Strengths

Once working and focused in tune with what they do... Read More

Organizational Culture and Creative Blocks ? the Similarities

Few Decision makers see the link between between creativity and... Read More

Get Meeting off To a Great Start

When asked what part of their job they find a... Read More

6 Steps to Effective Communication

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

Change or Die! To Change Your Organization, Hire a Business Coach

It is a common business axiom ? change or die.... Read More

Time Management Tip: Stop Micro-Managing Employees

If I was a fly on the wall what would... Read More

Tales from the Corporate Frontlines: The Best Incentives are Free

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

Get Out Of The Stone Age: Give Leadership Talks

160 years ago, the newly invented electric telegraph carried the... Read More

Profits and Business Success - 5 Profit Traps to Watch Out For

The old saying 'You have to spend money to make... Read More

Effective Ways to Give Performance Feedback

Consequences of Not Giving Effective FeedbackLet's take a look at... Read More

Lone Rangers Suffer without Tonto

A lone ranger is someone who prefers working in solitude... Read More

Einstein - Definition of Insanity

Insanity in the Sign & Graphics IndustryEinstein's DefinitionAlbert Einstein once... Read More

Business Innovation ? Value versus Quality

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

Never Punish Yourself or Others for Failures

If you want to find success in various ramifications, be... Read More

How To Get What You Really Want

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

Business Innovation ? Status Games

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

Interviewing: How to Stay Out of legal Hot Water

Some interviewers ask great questions; others ask dumb questions; and,... Read More

Be a Change Agent ( Part 1)

Aligning business organizations to be successful in the present and... Read More

Preparation: Your Companys Best Defense in Case of Catastrophe

You've hung out your shingle and are ready for business.... Read More

The Changing Boss-Secretary Relationship

THE CHANGING BOSS-SECRETARY RELATIONSHIP: Imagine a partnership at work. One... Read More

Managing People - No More Mr Tough Guy

I believe the media and our culture sends the wrong... Read More