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:

Technorati

Levin tries to follow Stanley: Wipeout, then a win
USA TODAY
By Christian Petersen, Getty Images Spencer Levin shows his frustration during his final-round 4-over 75 that cost him a win Sunday in the Waste Management Phoenix Open. By Christian Petersen, Getty Images Spencer Levin shows his frustration during his ...
Kevin Stanley Vindicated at Waste Management Open: A Fan's TakeYahoo! Sports
Five things we learned this week in golfESPN
Kyle Stanley Wins The Waste Management Phoenix OpenTechnorati
SB Nation -CBS News -Bleacher Report
all 869 news articles »


Project Management Software Project Insight Adds New Project Management Webinars
MarketWatch (press release)
IRVINE, CA, Feb 07, 2012 (MARKETWIRE via COMTEX) -- Project and portfolio management software, Project Insight is partnering with Core Performance Concepts, Inc. to offer a refreshed curriculum of 23 unique project management webinars for 2012.

and more »


Yahoo! Sports (blog)

Five things we learned from the Waste Management Open
Yahoo! Sports (blog)
So in an effort to condense the tournament coverage for you into a few quick hits, here are five things we learned from the Waste Management Open. Kyle Stanley's going to be just fine — Following a tournament to forget at the Farmers Insurance Open, ...
Waste Management Phoenix Open raises $50K for Keep Phoenix BeautifulPhoenix Business Journal
Scottsdale police cite swimmer at Phoenix OpenAZ Central.com
Waste Management Phoenix Open: 16th Hole Changing for the WorstBleacher Report
ABC15.com (KNXV-TV) -AZFamily -SB Nation (blog)
all 974 news articles »


Coastal Management cost estimates challenged
Juneau Empire
Juneau Mayor Bruce Botehlo, sponsor for the Alaska Coastal Management Program Initiative, turns to leave after being questioned at a joint meeting of the House and Senate Judiciary committees at the Capitol on Monday. By Pat Forgey Juneau Mayor Bruce ...

and more »


Ixonos marrieseZ Systems' World-Leading Content Management Solution With its ...
MarketWatch (press release)
HELSINKI, February 7, 2012 /PRNewswire via COMTEX/ -- Ixonos, a creative mobile solutions company and Finnish cloud solution provider, has made a deal with Norwegian web content management (WCM) and customer experience management (CXM) provider eZ ...

and more »


Alcatel-Lucent Makes Its Customer Experience Management Motive Clear
MarketWatch (press release)
The Motive Customer Experience Solutions (CXS) portfolio is designed to proactively address the consumer experience, providing a suite of software and expert services to help communications service providers manage their customer relationships over a ...
AlcaLu Gets Motivated About CEMLight Reading

all 27 news articles »


AIT Releases the Latest Version of the Industry-Leading Translation Management ...
San Francisco Chronicle (press release)
Advanced International Translations (AIT) has officially released the latest version of its Projetex solution, the industry-leading translation management system. Launched to support translation project managers at language service providers (LSPs) ...

and more »


McKay Management Adds to Maintenance Department
MarketWatch (press release)
BIRMINGHAM, Ala., Feb 06, 2012 (BUSINESS WIRE) -- McKay Management, an Associa company, is pleased to announce the addition of James Jones as its new Maintenance Supervisor where he will oversee the entire maintenance division for McKay managed ...

and more »


Merger Fuels Growth for Independent Investment Management Firms
MarketWatch (press release)
6, 2012 /PRNewswire via COMTEX/ -- Two well-acquainted investment management firms completed a long-planned merger last week, creating one of the larger independent money managers in Ohio with 19 employees and more than $450 million in assets under ...

and more »


LA Canyon News

Health Management Associates, Inc. Executes Definitive Agreement to Joint ...
MarketWatch (press release)
NAPLES, Fla., Feb 06, 2012 (BUSINESS WIRE) -- Health Management Associates, Inc. /quotes/zigman/229077/quotes/nls/hma HMA -1.62% today announced that it has executed a definitive agreement to joint venture five Oklahoma hospitals.
By: Gulf Coast Business ReviewGulf Coast Business Review

all 28 news articles »

Google News

home | site map
© 2006