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

The Associated Press

Oracle to pay $1.9B for Taleo, extends SAP rivalry The Associated Press NEW YORK (AP) ? Oracle Corp. is escalating its rivalry with German business-software maker SAP AG with a $1.9 billion purchase of Taleo Corp., a company that helps businesses hire and manage their employees. The proposed purchase announced Thursday ... Oracle Will Purchase Taleo for $46 a Share in Deal Valued at $1.9 BillionBloomberg Oracle to pay $1.9 billion for personnel software company, extends rivalry ...Washington Post Oracle buying Taleo for $1.9 billion, cloud war brewsReuters BusinessWeek -Wall Street Journal all 358 news articles »

TEXT-S&P revises Apollo Investment Corp outlook to stable Reuters (The following statement was released by the rating agency) -- Apollo Investment Corp. (AIC) has announced changes in management, a reduction in its dividend, and adjustments to its investment strategy. -- In our view, changes to the firm's investment ... Apollo Investment Changing Strategy, ManagementWall Street Journal Company News for February 9, 2012Zacks.com Apollo Investment's CEO Discusses Q3 2012 Results - Earnings Call TranscriptSeeking Alpha Economic Times -Tech24 all 28 news articles »

Integrated Asset Management Corp. Announces Results for the First Quarter of ... MarketWatch (press release) TORONTO, ONTARIO, Feb 09, 2012 (MARKETWIRE via COMTEX) -- Integrated Asset Management Corp. ("IAM") /quotes/zigman/18979 CA:IAM -7.14% today announced unaudited financial results for the quarter ended December 31, 2011. Review of the 3-Month Period ... and more »

Mildred Hailey to Retire From Bromley-Heath Tenant Management Corp. Patch.com Mildred Hailey to Retire From Bromley-Heath Tenant Management Corp. The Jackson Square housing development will be run by the Boston Housing Authority, at least in the short term. By Chris Helms It's the end of an era at Bromley-Heath, as the woman who ... and more »

State Street's Powers Seeks to Expand Active Money Management Bloomberg Scott Powers, head of State Street Corp.'s investments unit, said the Boston-based company is looking to increase its active management business. ?We're focused on broadening out our active capabilities,? Powers said during a presentation in New York ... and more »

Baja Mining Files Management Information Circular and Exposes Mount Kellett's ... MarketWatch (press release) VANCOUVER, BRITISH COLUMBIA, Feb 09, 2012 (MARKETWIRE via COMTEX) -- Baja Mining Corp. /quotes/zigman/31250 CA:BAJ +4.30% (otcqx:BAJFF) today advised shareholders that it has filed and is mailing its Management Information Circular for a Special ... and more »

Owl Creek hedge fund cuts stake in Navistar Reuters Feb 9 (Reuters) - New York-based Owl Creek Asset Management, a $7 billion hedge fund, reported a 7-percent stake in truck and engine maker Navistar International Corp, down from an 8.4 percent stake in December, a regulatory filing showed on Thursday. and more »

CPI Corp. Announces Leadership Transition MarketWatch (press release) "I look forward to working more closely with the management team and our associates across the country to help improve the Company's financial performance." Abel chaired the company's Audit Committee and the Nominating and Governance Committee, ... CPI Corp. to Trade on OTCQX as "CPIC"NEWS.GNOM.ES (press release) all 30 news articles »

Deyu Agriculture Corp. Acquires Deep Processed Food Manufacturer, Taizihu Group MarketWatch (press release) Forward looking statements are based upon the current plans, estimates and projections of Deyu Agriculture Corp.'s management and are subject to risks and uncertainties, which could cause actual results to differ from the forward looking statements. and more »

Moneycontrol.com

Thomson Reuters posts loss, $3 billion goodwill charge Reuters By Jennifer Saba | NEW YORK (Reuters) - Thomson Reuters Corp (TRI.TO) (TRI.N) reported a fourth-quarter loss on Thursday after taking a $3 billion non-cash goodwill impairment charge to account for the decline in its financial services business. Thomson Reuters posts loss, $3 bln goodwill chargeChicago Tribune Thomson Reuters hit by US$3-billion goodwill chargeFinancial Post Thomson NEWS.GNOM.ES posts loss, $3 billion goodwill charge (NEWS.GNOM.ES)NEWS.GNOM.ES (press release) all 52 news articles »