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:

Boston Globe

Firms Get 2 Days to Apply for Work on Rescue Plan
Wall Street Journal - 29 minutes ago
Allianz SE's Pacific Investment Management Co., better known as Pimco, has said it wants to serve as a manager, and other firms, such as Blackrock Inc. and ...
Paulson Talking to Bernanke, Working on TARP Program (Update4) Bloomberg
Outside experts hired for huge clean-up Sydney Morning Herald
Officials pledge to move quickly on rescue The Associated Press
Bloomberg - Bloomberg
all 221 news articles


Protera Technologies Is Now an SAP-Certified Provider of ...
MarketWatch - 11 hours ago
Protera has earned this coveted certification after meeting rigorous requirements of their ability to deliver application management services with quality ...
Wipro Among the First SAP Partners to Adopt Run SAP(R) Methodology MarketWatch
all 29 news articles


Advoco Dedicates a Service Arm to Concentrate on Enterprise Asset ...
MarketWatch - 10 hours ago
Advoco is a leading management and consulting services company headquartered in San Francisco, CA with offices in Greenville, SC and London, England. ...
Advoco Attracts Top Talent with Addition of Marty Osborn and ... MarketWatch
all 19 news articles


HRP Announces Changes to its Senior Management Group
MarketWatch - 9 hours ago
Ms. Clark remains Executive Vice President and General Counsel of Reit Management & Research LLC (RMR), HRP's manager, and will continue to supervise legal ...
HRPT Properties elects Lepore as COO CNNMoney.com
all 13 news articles


Updated Information Regarding Auction Preferred Securities Market ...
MarketWatch - 8 hours ago
BOSTON, Oct 06, 2008 (BUSINESS WIRE) -- MFS Investment Management(R) (MFS) today announced the availability of information on the results of the weekly ...


FOXSports.com

Strong management has Rays heading to ALCS
FOXSports.com - 1 hour ago
Shrewd management, however, is the biggest reason the Rays are in baseball's final four, and shame on any low-revenue team that fails to heed their example. ...


Research and Markets: IT Systems Management: Exploiting the ...
MarketWatch - 12 hours ago
The new, more holistic approach to systems management is that of simplification; so that the IT department can manage the technology stack at a higher level ...
Research and Markets:The Enterprise Content Management (ECM ... MarketWatch
all 15 news articles


IFX Forum Launches New Working Group for Card Management & Servicing
MarketWatch - 10 hours ago
"Card" is defined as the services related to Issuing, Management and Servicing of Credit, Debit, Prepaid and Private Label cards. ...


G & S Minerals Announces Management Changes; New Leadership to ...
International Business Times, NY - 8 hours ago
"The management changes were both a practical and strategic result of theCompany's agreement with Mayan Gold, Inc.," stated Charles Brown, ViceChairman. ...


Integrated Asset Management Corp. Announces Purchase of Remaining ...
MarketWatch - 12 hours ago
GPM is the real estate asset management division of IAM and has a very successful 26 year history of investing commitments from institutional clients in ...

Management - Google News

home | site map
Web Site Development - Search Engine Marketing: Dream Team Media