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:

Mines Management Inc. : Update - Prepares For Exploration On La Estrella Gold ...
Reuters
RELEASE 12-05 UPDATE - MINES MANAGEMENT PREPARES FOR EXPLORATION ON LA ESTRELLA GOLD-SILVER PROJECT Spokane, Washington - May 25, 2012 - Mines Management, Inc. (NYSE-Amex: "MGN", TSX: "MGT") (the "Company") is pleased to announce preparations, ...

and more »


New York Times (blog)

Management Buyouts Can Be Too Cozy
New York Times (blog)
That seems to be the case with the board of Venoco, a California oil company that is the subject of a proposed $770 million management buyout. On Jan. 16, the Venoco board of directors agreed to let the company be acquired by its chairman and chief ...



Bloomberg

Dell Close to Buying Quest for Computer-Management
BusinessWeek
By Serena Saitto and Aaron Ricadela on May 25, 2012 Dell Inc. (DELL) (DELL) is in advanced discussions to acquire Quest Software Inc. (QSFT) (QSFT), a maker of tools that help companies manage their computer systems, according to a person with ...
Dell Said Close to Buying Quest for Computer-ManagementBloomberg
Dell's Quest For Software Business Could Lead To Acquiring Quest SoftwareCRN
Report: Dell Looking to Buy Quest SoftwareChannelnomics
Forbes -Investor's Business Daily
all 83 news articles »


AsiaOne

JPMorgan Chase Risk Management Committee Missing Bank Directors, Financial ...
Huffington Post
What the committee's missing that all the other big banks have: people who worked as financial risk managers. The makeup of JPMorgan's committee hasn't changed since 2008, but the bank was warned last year that it wasn't up to the task of monitoring ...
JP Morgan's Risks Aren't Well-Managed Because JP Morgan Doesn't Want Sound ...Slate Magazine (blog)

all 31 news articles »


Bloomberg

Apollo Global Management Completes Acquisition of EP Energy
MarketWatch (press release)
Sam Oh, partner at Apollo, stated, "We are delighted to partner with one of North America's leading exploration and production franchises led by a world class team of managers. Our acquisition of EP Energy solidifies Apollo's natural resources platform ...
Apollo Completes Acquisition of EP EnergyPrivate Equity Hub (press release)

all 65 news articles »


Management Tip of the Day: Hire for passion
Reuters
The Management Tip of the Day offers quick, practical management tips and ideas from Harvard Business Review and HBR.org (www.hbr.org). Any opinions expressed are not endorsed by Reuters. "People are more creative when they feel passionate about their ...

and more »


SAS in Leaders Quadrant of Magic Quadrant for CRM Multichannel Campaign Management
MarketWatch (press release)
CARY, NC, May 25, 2012 (BUSINESS WIRE) -- SAS is in the Leaders quadrant in Gartner Inc.'s latest, "Magic Quadrant for CRM Multichannel Campaign Management"(1) This places SAS, the leader in business analytics and integrated marketing management, ...

and more »


Altiplano Minerals Ltd. Announces Changes to Management and Amendments to ...
MarketWatch (press release)
May 25, 2012 (ACCESSWIRE-TNW via COMTEX) -- May 25, 2012 - Vancouver, British Columbia - Altiplano Minerals Ltd. ("Altiplano" or the "Company") (apn:TSX-V) announces today several management changes as well as proposed amendments to certain matters ...

and more »


VIP Wins Project Management Contract for California Secretary of State
MarketWatch (press release)
SACRAMENTO, CA, May 25, 2012 (MARKETWIRE via COMTEX) -- The California Secretary of State awarded Visionary Integration Professionals (VIP) a contract for just under $1 million to provide project management services for the California Business Connect ...

and more »


Microsoft unveils AD Azure strategy, ID management reset
ZDNet (blog)
By John Fontana | May 25, 2012, 1:15pm PDT Summary: The software giant begins talking publicly about Windows Azure Active Directory service and its strategy to use it as the foundation for its Identity Management as a Service strategy.


Google News

Article List | Index | Site Map
All logos, trademarks and articles on this site are property and copyright of their respective owner(s).
The comments are property of their posters, all the rest is Copyright © 2006 CanadaSEEK.com - All Rights Reserved.