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: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Six Reasons to K.I.S.S. Six Reasons to K.I. Performance Management - By Assuming Nothing Unhappy as Jenny undoubtedly was, she held on very tightly to her job. After all, she had worked her way up over the years to the supervisory role she was in - and she wasn't going to let go. Managing Motivation "Without the chance to meaningfully participate in steering one's own destiny, without the opportunity to gain the sincere respect of one's own peers, without an honest stake in making the community more successful through one's own work and ideas, employability can quickly decay into generic training programs or bogus choices.. Why Training Fails Sometimes when I conduct my workshop on Effective Meetings, one of the participants will ask, "Where's my boss?"And I say, "Your boss claimed to be an expert on holding effective meetings."Then the person laughs. Collaboration: 3 Keys to Keeping Your Documents from Getting Lost in the Shuffle Often, collaborating documents in a team or in a business can feel like a complex sports play gone wrong. The ball gets passed off to the wrong person, dropped, or even lost. Hold Your Applause! It's amazing what you can accomplish if you don't care who gets the credit. Harry S Truman President Truman had decided that Secretary of State, General George Marshall's name should be attached to his plan for massive European relief following World War II. Understand What Flows Through Your Business to Find Improvement I remember once seeing a cartoon which showed two people working a counter. On the wall behind them was a sign which read, "Quality Work, Low Price, Fast Service - Pick Two. Terrible Meetings - Ten Ways to Spot Them! Sometimes, better than giving advice about how to run things well, it can be useful to have a hit list to notice to help you identify when things are less than productive. Meetings can be hugely productive, especially if you keep a sharp eye out for these Ten things:-No AgendaWhen there is no agenda, there is no opportunity to prepare, no framework for the meeting and no purpose. Top 10 Things NOT To Tell Angel and VC Investors I am not writing this to create a list of things not to say so people can hide the facts or in any way mislead potential investors. On the contrary I personally believe you must be 100% upfront with any potential investors, and even volunteer some weaknesses to be credible. Working with Hearing Impaired Employees - Giving Them a Fair Go Hearing impaired people often encounter difficulty at workbecause their disability isn't visible. I'd like to relateto you, briefly, the sorry saga of a young man who has recently been dragged through a performance managementprocess, essentially brought about by misunderstanding,frustration on his behalf, and failure by an employer tomake a 'reasonable adjustment' [Australian law includes the concept of reasonable adjustment which in effect means that employers are required to make reasonable adjustments necessary to enable employment opportunities for disabled people]in relation to this person's employment. Hiring for Success Hiring someone new to work in your business is one of the most critical decisions a business owner makes, although it is not always given the justice it deserves. If a position is vacant, or additional staff are needed, recruitment decisions are often driven by the pressure to get someone in quickly, rather than waiting for the best person to fill the job. Project Management, A Forgotten Perspective Effective project managers know how to get the job done, and get it done right. Success comes not only from wise selection of the team members and utilization of the best project management software tools; effective managers know how to lead, and how to encourage project team members to do their best. Making Change Work Shaky FoundationsWhilst over 60% of businesses will be looking to implement some form of business improvement initiative over the next 18 months, less than 1 in 4 of these change programmes will achieve any worthwhile results that are sustainable for a further 12 months post the introduction of change.This brings into focus two key problems:1. Examining the Relationship Between Employee Satisfaction and Customer Satisfaction Researchers have undertaken numerous studies to look at the connection between customer and employee satisfaction. A majority of these studies were able to uncover a correlation between employee satisfaction, customer satisfaction and profitability. 7 Tips for Growing Your Business You Do Not Want to Ignore: Business Strategies To Easily Implement Growing companies must always be ready for the next challenge. If you fail in meeting critical business challenges you will not grow. Dealing with Marginal Performers: The Therapeutic Approach --PREPARATION: The purpose of the therapeutic approach is to spark an employee toward improved performance through counseling. The manager's goal is to help the employee recognize the existence of a problem, accept the need for change, and formulate his or her own program for improvement. Diversity in the Workplace: Benefits, Challenges and Solutions Workplace diversity refers to the variety of differences between people in an organization. That sounds simple, but diversity encompasses race, gender, ethnic group, age, personality, cognitive style, tenure, organizational function, education, background and more. 9 Tips for Getting the Most From Your Conference Investment Tips for Getting the Most From Your Conference Investment All professionals attend conferences, seminars, and trade shows each year. Through my observation and person experience here are my top tips for maximizing your time and monetary investment in these events. Questions To Ask Employees You Want To Retain Times of cost cutting and downsizing has dramatically impacted the way employees look at their careers. Employees at all levels now know better than ever that job security is no longer something they can count on. Do the People in Your Organisation Dress For Success? What really amazes me, with all the personal and professional development seminars people attend, from executives in corporate world, business owners and employees alike, very little investment has been made into the way they look .. |
home | site map | contact us |