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:

Wound Management Sells Non-Core Subsidiary; Intends to Focus on CellerateRX ...
MarketWatch (press release)
FORT WORTH, Texas, Feb. 7, 2012 /PRNewswire via COMTEX/ -- Wound Management Technologies, Inc., (otcqb:WNDM | WNDM.PK), an emerging innovator in advanced wound care solutions, today announced that it has sold its wholly-owned subsidiary, Secure eHealth ...

and more »


Revenue Management Systems, Inc. Collaborates with Dr. Larry Weatherford
MarketWatch (press release)
SEATTLE, Feb 07, 2012 (BUSINESS WIRE) -- Revenue Management Systems, Inc. ("RMS") is pleased to announce its agreement with Dr. Larry Weatherford for consultation and collaboration on the mathematical models within airRM -- the state-of-the-art revenue ...

and more »


Quaker Chemical Management Services Achieve Maximum Value for Customers
MarketWatch (press release)
Quaker delivers this support with Quaker Chemical Management Services (QCMSsm), a comprehensive management approach to help manufacturers achieve maximum value by effectively using chemical products. After Quaker was chosen as the preferred Chemical ...

and more »


Viewfinity Privilege Management Earns High Marks in Independent Third-Party Review
MarketWatch (press release)
WALTHAM, MA, Feb 07, 2012 (MARKETWIRE via COMTEX) -- Viewfinity ( www.viewfinity.com ), the innovator of privilege management solutions, today announced that Viewfinity Privilege Management has achieved outstanding performance as a complete software ...

and more »


Project Management Software Project Insight Adds New Project Management Webinars
MarketWatch (press release)
IRVINE, CA, Feb 07, 2012 (MARKETWIRE via COMTEX) -- Project and portfolio management software, Project Insight is partnering with Core Performance Concepts, Inc. to offer a refreshed curriculum of 23 unique project management webinars for 2012.

and more »


CombineNet Now Offers Contract Management Solution Featuring Integration with ...
MarketWatch (press release)
7, 2012 /PRNewswire via COMTEX/ -- CombineNet, Inc., the leading provider of best-in-class online sourcing technology solutions for global supply chains, announced it has added a robust contract lifecycle management offering with integration to the ...

and more »


Conductor Searchlight Now Includes Enhanced Task Management and SEO Workflow ...
MarketWatch (press release)
NEW YORK, NY, Feb 07, 2012 (MARKETWIRE via COMTEX) -- Conductor, the leading provider of SEO technology software, announces the launch of a suite of innovative SEO workflow and task management features available in its leading SEO platform, Searchlight ...

and more »


Dimension Data Acquires Telecom Expense Management Provider, Xigo
MarketWatch (press release)
NEW YORK, Feb 07, 2012 (BUSINESS WIRE) -- Dimension Data, the $5.8 billion global specialist IT solutions and services provider today announced that it has acquired Xigo, a US-based leading provider of telecommunications expense management (TEM) ...

and more »


Experian Marketing Services Appoints Marshall Stanton as Vice President of ...
MarketWatch (press release)
This new role combines an in-depth knowledge of operations, project management, direct technical support, and the ever-important relationship management function that puts the client at the center of operations for an optimal, seamless and enchanting ...

and more »


Frank Crystal & Company Names Michele Centeno Senior Managing Director
MarketWatch (press release)
NEW YORK, Feb 07, 2012 (BUSINESS WIRE) -- Frank Crystal & Company, one of the nation's largest independent insurance brokerage firms, today announced that Michele Centeno has joined the company effective February 7 as senior managing director, ...

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