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:

US Asset Management Survey Shows the Influence of Risk Management is Increasing
San Francisco Chronicle (press release)
Ernst & Young's 2012 survey of risk management leaders at US asset management firms shows that despite increased influence, firms must address key challenges, especially in the areas of monitoring and risk reporting. New York, NY (PRWEB) May 21, ...

and more »


Advanced Wound Management Market Outlook in BRICS (Brazil, Russia, India ...
MarketWatch (press release)
GlobalData's new report, "Advanced Wound Management Market Outlook in BRICS (Brazil, Russia, India, China, South Africa) to 2017" provides key market data on the Advanced Wound Management market in the BRICS countries. The report provides value ($m), ...

and more »


www.waterstechnology.com

Pershing Announces Groundbreaking Collateral Management Technology for Fund ...
MarketWatch (press release)
JERSEY CITY, NJ, May 21, 2012 /PRNewswire via COMTEX/ -- Pershing, a BNY Mellon company, today announced the recent launch of two new applications as part of the organization's extensive Enterprise Collateral Management offering that automate the ...
Pershing Introduces Enhanced Collateral Management Applications for Fundswww.waterstechnology.com

all 12 news articles »


Houston Chronicle

BMC Software Responds to Elliott Management's Letter
MarketWatch (press release)
HOUSTON, May 21, 2012 (BUSINESS WIRE) -- BMC Software, Inc. (NASDAQ:BMC) (the "Company" or "BMC"), the recognized leader in Business Service Management, today issued the following statement in response to the press release issued earlier today by ...
BMC takeover battle heats up as Elliott fires backHouston Chronicle (blog)
Elliott Corrects BMC Board's Statements And Requests Additional Information ...PR Newswire (press release)

all 16 news articles »


EMC Transforms Infrastructure Management with New DataBridge Enterprise ...
MarketWatch (press release)
New EMC® DataBridge(TM) enterprise management tool transforms how customers consume and manage IT operations data. DataBridge "mashes up" or converges IT operations data, transforming silos of disparate compute, storage and network management ...
EMC Releases DataBridge Enterprise Management SoftwareeWeek

all 11 news articles »


Emergency Management Accreditation Program Fully Accredits Huntington District
MarketWatch (press release)
HUNTINGTON, W.Va., May 21, 2012 /PRNewswire via COMTEX/ -- The Huntington District of the US Army Corps of Engineers achieved full accreditation from the Emergency Management Accreditation Program (EMAP). This makes the Huntington District the first ...

and more »


V3.co.uk

Cloud Management Plays Big Role in 42 EMC World Product Announcements
NetworkComputing.com
EMC has kicked off its customer and partner event with 42 product announcements across its storage, backup, virtualization and management portfolio, and a major push into cloud computing. Along with the usual storage and backup rollouts, ...
EMC World: Storage News Wrap-UpInformationWeek
Largest-Ever Wave of EMC Innovation Makes Hybrid Cloud Transformation a RealityMarketWatch (press release)
EMC Unveils Long List of New Cloud, Storage ProductseWeek

all 64 news articles »


Care Management Delivers Better Health for Millions
MarketWatch (press release)
BROOMFIELD, Colo., May 21, 2012 (BUSINESS WIRE) -- Millions of patients nationwide are receiving better healthcare with the help of care management programs that use advanced technology to assist in improving medical team coordination and communication ...

and more »


Beverly Hills Wealth Management Opens San Diego Office, Expands Advisory Group
MarketWatch (press release)
SAN DIEGO, May 21, 2012 (BUSINESS WIRE) -- --Former Morgan Stanley advisor, Taylor Schulte joins the BHWM team Beverly Hills Wealth Management (BHWM), a registered investment advisory firm serving high net worth individuals, families, and businesses, ...

and more »


Family Express Optimizes Inventory Management With Retalix
MarketWatch (press release)
DALLAS, May 21, 2012 (GlobeNewswire via COMTEX) -- Family Express(R) of Valparaiso, Ind. recently improved its inventory management operations significantly by deploying Retalix(R) Ltd.'s (NASDAQ:RTLX) Demand-Driven Replenishment solution across its ...

and more »

Google News

Acne - Advertising - Aerobics & Cardio - Affiliate Revenue - Alternative - Attraction - Auction - Audio Streaming - Aviation - Babies & Toddlers - Beauty - Blogging & RSS - Book Marketing - Book Reviews - Branding - Breast Cancer - Broadband Internet - Muscle Building - Careers & Employment - Coaching - Coffee - College & University - Cooking Tips - Copywriting - Crafts & Hobbies - Creativity - Credit - Cruising & Sailing - Currency Trading - Customer Service - Data Recovery - Dating - Debt Consolidation - Debt Relief - Depression - Diabetes - Divorce - Domain Names - E-books - Ecommerce - Elder Care - Email Marketing - Entrepreneurialism - Ethics - Exercise - Ezine Marketing - Ezine Publishing - Fashion & Style - Fishing - Fitness Equipment - Forums - Games - Goal Setting - Golf - Grief Loss - Hair Loss - Happiness - Hardware - Holidays - Home Improvement - Home Security - Humanities - Humor - Innovation - Inspirational - Insurance - Interior Decorating - Internet Marketing - Investing - Landscaping & Gardening - Language - Leadership - Leases & Leasing - Loans - Lung, Mesothelioma & Asbestos - Management - Marketing - Marriage & Wedding - Meditation - Mobile & Cell Phone - Mortgage & Refinancing - Motivation - Motorcycles - Music - Negotiation - Network Marketing - Networking - Nutrition - Organizing - Outdoors - Parenting - Personal Finance - Personal Tech - Pets - Philosophy - Photography - Poetry - Politics - Positive Attitude - PPC Advertising - Press Release - Pregnancy - Presentation - Psychology - Public Speaking - Real Estate - Recipes - Relationships - Sales - Sales Management - Sales & Teleselling - Sales Training - Satellite TV - Science - Security - SEO - Site Promotion - Small Business - Software - Spam Blocker - Spirituality - Stocks & Mutual Funds - Strategic Planning - Stress Management - Structured Settlements - Success - Supplements - Taxes - Team Building - Time Management - Top7-Or-10-Tips - Traffic Building - Vacation Rentals - Video Conferencing - Video Streaming - VOIP - Wealth Building - Web Design - Web Development - Web Hosting - Weight Loss - Wine & Spirits - Writing - Writing Articles - Yoga

Top
Main Home Email Category Home