Management Information

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


MORE RESOURCES:

Reuters

CORRECTED: Management wins bid for Lehman's Neuberger
Reuters - 1 hour ago
PK: Quote, Profile, Research, Stock Buzz) prized asset management unit Neuberger Berman has been won by a team consisting of Neuberger's management, ...
Neuberger Berman Management, Lehman to Purchase Investment Unit Bloomberg
Neuberger to Be Acquired by Management MarketWatch
Three Bidders Emerge for Lehman Investment Management Unit Wall Street Journal
New York Times - Bloomberg
all 293 news articles


Upcoming CyberShift Webcast Examines the ROI of SaaS-Deployed ...
MarketWatch - 2 hours ago
Through an automated workforce management solution -- especially using the SaaS-based delivery model -- organizations can leverage their workforces to ...


Everest Software Partners with Foxfire to Offer Integrated ...
MarketWatch - 1 hour ago
Foxfire specializes in Warehouse Management Systems (WMS). Comprised of software, hardware, and professional services, Foxfire's WMS solution is ideal for ...


SuccessFactors' Professional Edition Enhances Orion Bank's ...
MarketWatch - 4 hours ago
the global leader in on-demand performance and talent management solutions, today announced Orion Bank has selected the SuccessFactors Professional Edition ...


Research and Markets: Decision Matrix: Selecting an Institutional ...
MarketWatch - 1 hour ago
... of the "Decision Matrix: Selecting an Institutional Performance Management Solution in Higher Education (Competitor Focus)" report to their offering. ...
Research and Markets: Selecting a Managed Network Services Vendor ... MarketWatch
all 12 news articles


Goldman wealth management unit hit by fund's decline: report
Reuters - 10 hours ago
This decline in the fund, called Goldman Sachs Liquidity Partners 2007, has hurt the company's plans to expand its wealth management operations, ...
Another Goldman unit hit by decline Financial Times
Another Goldman unit hit by decline FT Alphaville
all 18 news articles


The Money Times

Services contracting at the worst pace ever
MarketWatch - Dec 3, 2008
... contracting in November at the fastest pace on record, according to a survey of companies released Wednesday by the Institute for Supply Management. ...
RPT-TABLE-US ISM non-manufacturing index 37.3 in Nov Reuters
Service sector weakens in November CNN
ISM: New Orders, Prices Plummet TheStreet.com
Seeking Alpha - MarketWatch
all 854 news articles


RCN Management to Present at UBS 36th Annual Global Media ...
MarketWatch - 2 hours ago
, , ) , a leading provider of all-digital television, high-capacity data, and voice services to residential, business customers and service providers, ...
Avaya Global Services Offer to Help Enterprises Optimize Existing ... MarketWatch
all 19 news articles


Qualia Clinical Services: New Director, Data Management and ...
MarketWatch - 20 hours ago
"Data Management and Regulatory Affairs are a very integral part of what we do at Qualia, and we are very confident that Dr. Por's background and expertise ...


MMM Successfully Completes Contract Management Project for ERDAS
MarketWatch - Dec 3, 2008
Morris, Manning & Martin's Contract Management System helps businesses of all sizes manage their contracts more efficiently and effectively. ...

Management - Google News

home | site map
© 2006