Using Outlook to Count Responses

Home
>
Business Management
>
Using Outlook to Count Responses

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

In The News:

Yahoo! News: Top Stories

Ford says CEO will work for $1 to get loans (AP)

AP - Ford Motor Co. will tell Congress that it plans to return to a pretax profit or break even in 2011 when the Detroit Three automakers' CEOs appear before lawmakers this week to request $25 billion in government loans.

Stocks bounce back after steep selloff (AP)

AP - Wall Street rebounded Tuesday, regaining some of the ground lost in the previous session's huge drop, as the potential for a bailout of the beleaguered auto industry helped calm investors. The Dow Jones industrials rose nearly 225 points, regaining a third of Monday's nearly 680-point plunge.

Ford Nov. sales drop 30 pct., Toyota falls 34 pct. (AP)

AP - Ford says its November U.S. light vehicle sales tumbled 31 percent amid a continued slump in consumer spending and tight credit markets. Toyota's sales fell 34 percent despite its extension of zero-percent financing on a dozen vehicles.

Thai airports to reopen after government falls (AP)

AP - Thailand's prime minister was ousted Tuesday after weeks of protests closed the capital's airports, stranding 300,000 travelers. Protesters promised to lift their siege, and international flights were expected to resume Friday.

Iraq's notorious 'Chemical Ali' given second death sentence (AP)

AP - A special Iraqi court sentenced Saddam Hussein's notorious cousin, "Chemical Ali" Hassan al-Majid, to death Tuesday after convicting him of crimes against humanity for his part in crushing the 1991 Shiite uprising in southern Iraq.

Obama seeks to assure nervous governors on economy (AP)

AP - President-elect Barack Obama pledged quick work Tuesday on an economic recovery plan to include tax cuts and increased federal spending, and told the nation's governors he wants their advice in designing a package to help their hardhit states.

U.S. official: India knew of plot on Mumbai coast (AP)

AP - India received a warning from the United States before last week's attacks in Mumbai that militants were plotting a waterborne assault on the city, a senior U.S. official said Tuesday as domestic intelligence officials said they were aware of a Pakistan-based plot.

Body-swap illusion tricks mind in new study (AP)

AP - Shaking hands with yourself is an amusing out-of-body experience. The illusion of having your stomach slashed with a kitchen knife, not so much.

Britney Spears to embark on `Circus' tour in March (AP)

AP - Britney Spears is taking her "Circus" act on the road.

Burress arrives at Giants Stadium (AP)

AP - Plaxico Burress arrived at Giants Stadium on Tuesday, facing the possibility that his career with the Super Bowl champions could be over and he could land in jail after accidentally shooting himself in the thigh at a nightclub.

Big Three automaker plans hit congressional desks (Reuters)

Reuters - U.S. automakers started to submit plans demanded by Congress as the Big Three's CEOs and lawmakers gird for debate over a $25 billion bailout the industry says it needs to survive.

Georgia votes in key Senate run-off election (Reuters)

Reuters - The state of Georgia votes in a run-off election for the Senate on Tuesday that will help decide whether Democrats gain a big enough majority in the chamber to ram through legislation virtually at will.

Thai court disbands ruling party (Reuters)

Reuters - Thai Prime Minister Somchai Wongsawat was banned from politics for five years and his party disbanded on Tuesday, spurring jubilant anti-government protesters to end their blockades of Bangkok's airports.

Oil retreats below $49 as brief rally fades (Reuters)

Reuters - Oil fell below $49 a barrel on Tuesday, after reversing early losses in response to a rally in U.S. and European shares.

India demands Pakistani hand over fugitives (Reuters)

Reuters - India demanded Pakistan hand over 20 of its most-wanted fugitives as a sign of good faith, while both sides on Tuesday tried to cool tensions over the Mumbai attacks before a visit by Washington's top diplomat.

Iraq's "Chemical Ali" gets second death sentence (Reuters)

Reuters - An Iraqi court sentenced Saddam Hussein's cousin "Chemical Ali" to death Tuesday for the killing of thousands of Shi'ites in a ruthless crackdown on their uprising after the 1991 Gulf War.

Two U.S. soldiers charged for abusing Afghans (Reuters)

Reuters - Two U.S. soldiers serving in Afghanistan have been charged with the abuse of Afghan detainees, the U.S. military said Tuesday.

Report: Chances of WMD attack in major city likely (Reuters)

Reuters - The chances of a terror attack on a major city somewhere in the world using weapons of mass destruction are better than even, according to a task force mandated by the U.S. Congress, The Washington Post reported in its Tuesday edition.

Thai protests to end after court ousts govt (AFP)

AFP - Thai anti-government activists on Tuesday agreed to end protests that have paralysed Bangkok's airports, after a court stripped Prime Minister Somchai Wongsawat of his post and outlawed the ruling party.

Pakistan offers 'joint investigation' into Mumbai attacks (AFP)

AFP - Pakistan offered on Tuesday to work hand-in-hand with India to track down those responsible for the Mumbai attacks but declined to respond immediately to a demand that it hand over 20 terrorist suspects.

Using Outlook to Count Responses

Business Management Business Management