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:

Web 2.0 and Sales Process Management
TechRepublic
Overview: This report discusses how Web 2.0 systems and applications can support management of sales processes. (Is this item miscategorized? ...
From Reporting to Performance ManagementTechRepublic
2010 Service & Leadership Trends in Customer SupportTechRepublic
SAP Business All-in-One Fast Start ProgramTechRepublic
TechRepublic
all 58 news articles »


Asia Stocks Post Weekly Advance on BOJ, Manufacturing Growth
BusinessWeek
Manufacturing in the US expanded at a faster pace than forecast in August, according to The Institute for Supply Management's factory index on Sept. 2. ...

and more »


Kansas City Star

Summary Box: Service sector growth slows in August
The Associated Press
GROWTH SLOWING: The Institute for Supply Management said its service-sector index fell to 51.5 last month from 54.3 in July. The number indicates growth for ...
U.S. manufacturing grows again in August for 13th straight monthBizjournals.com

all 326 news articles »


Kansas City Star

Heads up | UMB unit buys asset management company
Kansas City Star
Scout Investment Advisors will more than double its assets under management by acquiring Reams Asset Management Co., the companies said Thursday. ...
Scout Investment Advisors to Acquire Reams Asset Management CompanyMarketWatch (press release)
Scout Investment To Buy Reams AMEmii.com
Scout Buys a Fixed-Income SpecialistMutualFundWire.com (subscription)

all 35 news articles »


Reuters

Management Tip of the Day: 3 ways to improve performance reviews
Reuters
BOSTON (Reuters) - The Management Tip of the Day offers quick, practical management tips and ideas from Harvard Business Review and HBR.org (www.hbr.org). ...

and more »


Peter Orszag To Write New York Times Column
Huffington Post (blog)
Former director of the Office of Management and Budget Peter Orszag will join the New York Times as a columnist, the newspaper announced Friday. ...

and more »


Quest Oil Management Provides Update
MarketWatch (press release)
In management's view, B&B Oil's assets in the Midkiff and Hawkeye Fields in Texas are economically attractive and geologically sound properties that have ...

and more »


International Business Times

Mariner Real Estate acquires loan portfolio
BusinessWeek
Mariner Real Estate Management LLC said Friday that it worked with bank regulators to buy a portfolio of real estate loans worth about $760 million. ...
Mariner Real Estate Management Acquires $760 Million FDIC Real Estate Loan ...Benzinga
Leawood-based Mariner buys $760 million in real estate loans from FDICKansas City Star
FDIC sells another $760 million in REOHousing Wire

all 24 news articles »


Competitive Technologies Announces Management Changes
MarketWatch (press release)
... Inc. (OTCQB:CTTC) today announced that its Board of Directors has made organizational changes to the management of the Company. ...

and more »


ESPN

Villa's Three Man Management Solution: Too Many Cooks Going To Spoil The Broth?
Bleacher Report
So to add experience and to keep the fans happy, In the papers today, it is being speculated that there will be a three man management "Dream Team". ...
Aston Villa News: Houllier-McDonald Management Set For VillaCradlebay (blog)

all 111 news articles »

Google News

home | site map
© 2006