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

---

Google News Updated : Tue, 07 Oct 2008 20:50:00 GMT Cough, Cold Drugs Not for Kids Under 4 - WebMD CBS News Cough, Cold Drugs Not for Kids Under 4 WebMD - 2 hours ago By Miranda Hitti Oct. 7, 2008 -- Don't use over-the-counter pediatric cough and cold drugs in kids younger than 4. Leading makers of over-the-counter pediatric cough and cold drugs are putting that message on the products' labels, according to the ... Cold, Cough Medicines for Children Get Added Warnings (Update3) Bloomberg Drug Companies Say No Cold Meds for Kids Under 4 Washington Post Chicago Tribune - New York Times - Bizjournals.com - The Associated Press all 1,485 news articles Publ.Date : Tue, 07 Oct 2008 18:48:20 GMT Bernanke hints at possible interest rate cut - MarketWatch The Associated Press Bernanke hints at possible interest rate cut MarketWatch - 31 minutes ago By Greg Robb, MarketWatch WASHINGTON (MarketWatch) - Federal Reserve Chairman Ben Bernanke opened the door on Tuesday for a possible interest rate cut to help rescue the economy from a severe downturn, admitting that the global panic in the financial ... Video: Bernanke signals possible rate cut ReutersVideo Bernanke: Economic outlook weaker CNNMoney.com New York Times - Forbes - Reuters - MSN Money all 988 news articles Publ.Date : Tue, 07 Oct 2008 20:18:10 GMT Sleuth's Presidential Debate Watch Game - Washington Post Sleuth's Presidential Debate Watch Game Washington Post - 41 minutes ago Tonight's debate watch games probably won't be as much fun as last week's Palin Bingo. But don't fret, there are still games to be played during this second presidential debate between John McCain and Barack Obama. 'Aggressive' debate expected between McCain, Obama CNN * McCain looks for way to stop Obama's momentum Reuters The Associated Press - MSNBC - U.S. News & World Report - TIME all 1,199 news articles Publ.Date : Tue, 07 Oct 2008 20:08:21 GMT Thai Army Sends Troops to Help Police Keep Peace - Washington Post Voice of America Thai Army Sends Troops to Help Police Keep Peace Washington Post - 4 hours ago Thailand's military agreed Tuesday to deploy hundreds of unarmed soldiers to the streets of Bangkok to help police restore order after violent clashes between police and protesters that left at least 1 person dead. Video: Raw Video: Tear Gas Fired at Thai Protestors AssociatedPress Troops deployed as one dead, hundreds hurt in Thai protests AFP Reuters UK - Hindu - eTaiwan News - The Standard all 1,327 news articles Publ.Date : Tue, 07 Oct 2008 16:12:03 GMT Qantas Involved in Another Air Incident - New York Times NEWS.com.au Qantas Involved in Another Air Incident New York Times - 25 minutes ago By Liz Robbins It has been 20 years since Dustin Hoffman’s character Raymond Babbitt in “Rain Man” made Qantas synonymous with air safety, claiming he would only fly the Australian airline because it had never crashed. Qantas passengers arrive in Perth after mid-air ordeal ABC Online Fifteen badly hurt as Qantas jet drops Sydney Morning Herald The Standard - Taipei Times - United Press International - NEWS.com.au all 366 news articles Publ.Date : Tue, 07 Oct 2008 20:24:06 GMT Wells Fargo may get lion's share of Wachovia deposits: report - MarketWatch Sify Wells Fargo may get lion's share of Wachovia deposits: report MarketWatch - 32 minutes ago By John Spence, MarketWatch BOSTON (MarketWatch) -- Wells Fargo & Co. may get as much as 80% of Wachovia Corp.'s deposits, with the remainder likely going to Citigroup Inc., according to a published report Tuesday. Citi, Wachovia, Wells temporarily halt litigation Bizjournals.com Wachovia shares waver as Citi, Wells Fargo wrangle Forbes BloggingStocks - Washington Post - New York Times - CNNMoney.com all 7,781 news articles Publ.Date : Tue, 07 Oct 2008 20:17:51 GMT AIG's ex-CEOs blamed for crisis - CNNMoney.com Los Angeles Times AIG's ex-CEOs blamed for crisis CNNMoney.com - 1 hour ago House panel chairman says executives got undeserved riches, while ex-CEOs blame accounting rules and market conditions for leading to $85B bailout. Joe Cassano: The Man Who Brought Down AIG? Washington Post AIG CEOs Blame Each Other, Accounting for Insurer's Downfall Bloomberg Wall Street Journal - Financial Times - New York Times - Forbes all 768 news articles Publ.Date : Tue, 07 Oct 2008 19:11:18 GMT Make Data Feed Websites Amazon Content

PARLOT::Ebooks, Scripts, Websites, and more...

Adsense websites

Forget The Sandwich Technique

Do you remember being told to use the "sandwich" technique... Read More

Deciding What to Delegate

DECIDING WHAT TO DELEGATE: Once the benefits of delegation are... Read More

Using Employee Opinions Effectively When Designing HR Programs

Using Employee Opinions Effectively When Designing HR ProgramsEmployee opinion is... 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

Problem-Solving Success Tip: Measure the Right Things.

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

How to Get Your Procedures Project Done

Wouldn't it be nice for business owners and executives to... Read More

One Thing You Cant Hide

One of the most important of all motivators at work... Read More

Effective Meetings by Phone - Part 2, How to Hold a Teleconference

Even a well-planned teleconference can go poorly. Some people treat... Read More

Innovation Management ? forced into it!

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

Top 7 Methods to Empower Employees

How many times have you asked someone to do something... Read More

Internal Control - The Why and How

Many retailers do not have good internal controls in place... Read More

Training Adults, Not Teaching Children

Adults are vulnerable to personal and professional embarrassment from poor... Read More

Interviewing Candidates: 3 Ways to Avoid Snap Judgments

Have you ever hired the wrong person? If so, perhaps... Read More

10 Ways To Work Through A Business Slowdown

In running any kind of business, it's inevitable that sometimes... Read More

What Every Manager Should Know About How to Conduct Successful Meetings

Do you announce a meeting and find either no one... Read More

Creativity Management ? Quality from Quantity

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

Leaning Toward Change

Seduced by the publicity surrounding the impact of Lean on... Read More

Let the Professionals Help You Out - Outsource

As your website grows in terms of attracting more footfalls,... Read More

5 Interviewing Mistakes That Can Lead To Hiring The Wrong Person

Mistake #1: Going with the flowInexperienced interviewers sometimes fall into... Read More

Making Meetings Work

We have all attended meetings that were boring, mindless and... Read More

Get Meeting off To a Great Start

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

Make Change Easy - Get Involved!

There are wild variances in how much involvement organisations are... Read More

You Didnt Use Brainstorming to Select Your Measures, Did You?

IntroductionWhen Alex Osborn invented the creativity technique called brainstorming, I... Read More

Poor Employee Performance: How to Deal

KEEP WRITTEN RECORDS: "Document !Document! Document!" Keep a record of... Read More

Loyalty, Motivation And Work-Life Balance

Managers who aren't loyal to their people can't expect loyalty... Read More