Management Information Information Research

Tell a Friend about this Site

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

Bankrupt General Growth faces problem of plenty
Reuters
General Growth's proposal to emerge independently is to be backed by three investors -- Brookfield Asset Management (BAMa.TO), Fairholme Capital Management ...
Glenn J. Rufrano Steps Down from General Growth Properties Board of Directors ...MarketWatch (press release)
Will General Growth emerge from Chapter 11 in six pieces?Chicago Daily Herald
General Growth to Submit New Proposal, Lawyer SaysBusinessWeek
Forbes -New York Times
all 323 news articles »


Manitex Revises its Management Information Circular Pertaining to the General ...
MarketWatch (press release)
MONTREAL, QUEBEC, Mar 19, 2010 (MARKETWIRE via COMTEX) -- Manitex Capital Inc. (TSXV:CA:MNX) announced today that it has revised its Management Information ...

and more »


Hawaii's 'Lax Management' Freezes $1 Billion Deal
BusinessWeek
March 19 (Bloomberg) -- Hawaii State Auditor Marion M. Higa found “lax management” of the state's treasury led to a $1 billion ...

and more »


County looks to revive Vets Hall management board
San Jose Mercury News
SANTA CRUZ - Two weeks after the county released the management group that runs the Veterans Memorial Building, county leaders are ...

and more »


Coca-Cola announces management changes
Reuters
N) announced a series of management changes on Friday, less than a month after saying it planned to acquire its North American bottling operations . ...

and more »


USA Today

Key federal management lawmakers brace for health care vote
GovExec.com
... care reform legislation on Sunday, some Democratic lawmakers who play key roles in federal management issues could prove to be crucial swing votes. ...
To Preserve Profits, Medicare Advantage Plans Turn to Medical ManagementInsurance News Net (press release)

all 454 news articles »


Novell Successfully Implements Callidus Monaco On-Demand to Optimize Sales ...
MarketWatch (press release)
Callidus Objective Management enables organizations to design and deploy pay-for-performance initiatives to every employee. The self-service application ...

and more »


Merrill Lynch to NYC: 'What Do You Want to Retire?'
MarketWatch (press release)
The billboard installation further highlights the Merrill Lynch Wealth Management commitment to delivering personalized financial advice, along with a broad ...

and more »


Diamond Management & Technology Consultants Commends FCC National Broadband Plan
MarketWatch (press release)
While at Diamond Management & Technology Consultants, prior to his FCC service, Garr advised federal, state, and local agencies on a variety of strategic ...

and more »


Tampa Bay Business Journal

Directors, management, examiners share blame for First State failure
Tampa Bay Business Journal
Instead, the bank is defunct, failing in part because its board of directors and management didn't adequately control the risks associated with growth and ...

and more »

Google News



MaineBannerExchange

home | site map
© 2006