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
Related News
|
 |
|
|
RELATED ARTICLES
Turbo Charge Your Career With The Most Powerful Leadership Tool Of All: The Leadership Talk: Part 1
Leaders speak 15 to 20 times daily. You speak at meetings, you speak across their desks, you speak on the phone, you speak in e-mails, you speak at lunch, beside the water cooler, and on elevators, etc.
How To Get 10% More Work Out Of Your Employees
It is getting harder to run a business for a profit. We
are faced with rising costs, lowered demand etc. Our
businesses have to be super effective just to keep up.
Firing Someone Without Resentment
Firing, sacking, letting go or terminating people is unpleasant. There are ways to minimise resentment, but why bother? Because most legal action and unpleasantness stems from dissatisfaction/resentment about the way things were handled - about how rather than what happened. Dismissal can be unfair because of the reason, or the way it was done, so you need to be extremely careful. In the law regarding employer-employee relationships, fairness is key. You must be fair, and be seen to be fair. But fairness, like beauty, is in the eye of the beholder - after being terminated, very few people have clear vision!
Innovation Management ? Diversity Can Make All The Difference
Companies are welcoming a diverse range of employees (The Sunday Times, April 10 2005). Doh!
Compensation and Six Sigma Black Belts
One of the more ambiguous elements of a Six Sigma project is the level and type of compensation the organization should give to its Six Sigma leaders and team members. On the one hand, setting compensation is not an integral part of any stage of a Six Sigma project; on the other hand, compensation is an important instrument to build loyalty and a sense of accomplishment that is a crucial element to the organization's Six Sigma success. While there are no hard and fast rules for compensation for Six Sigma leaders and team members, there are some good ways to think about how to productively provide compensation to your people.
Black Belts are the key change agents for the Six Sigma process. They have an important role and should be compensated accordingly. If your organization is large enough to have people dedicated full-time to leading Six Sigma projects, their base pay should be in the top of your organization's range for their level of management. If your organization is asking a manager to also devote part of his or her time to leading a Six Sigma project, you need to find some way to compensate them for their extra efforts. In addition to base pay, you can find creative ways for recognition for completed projects. Black Belts should receive some special and public recognition for their efforts, whether it is dinners, award ceremonies, plaques, etc. Whatever fits best with your organizational culture. Such recognitions should not be strictly limited to Black Belts either, as acknowledging the achievements of all who participated in and benefit from the Six Sigma project should receive some sort of recognition to boost morale.
Monetary bonuses are another way to compensate people for successful Six Sigma projects. Since Six Sigma projects are about helping the organization make more money it makes sense to share some of the cost savings from Six Sigma projects with the Six Sigma team. Develop a structured, team-based process improvement bonus system that will appropriately benefit each worker in the organization. As measurable and lasting improvements are made to processes, it is appropriate to share a part of the financial gains with employees. Just be sure there is a formal performance appraisal system that will identify what is to be accomplished, what success looks and feels like, and how an employee will be compensated, and that this is fully communicated to everyone. Such an organizational goal-sharing program will effectively support Six Sigma efforts. Being able to link compensation to Six Sigma implementation is much easier in a small company compared to a larger company.
Bonuses can also be paid to Black Belts, but with differences due to their unique status. Instead of paying bonuses to Black Belts as a share of actual process improvement, pay them bonuses related to specific project goals. There is a danger in directly tying their bonus with a share of the actual improvements as they may be motivated to inflate or misconstrue actual gains. That still leaves you with many concrete project milestones that can be the basis for their compensation.
From Boring to Interesting - Making Training Effective
Being a good trainer requires experience and skill. Experience comes from practice and skill from learning the theories, applying them, getting feedback and consciously improving.
Can You Sleep While The Wind Blows?
Let me repeat a story I heard many years ago that has stuck with me throughout my life. The lessons from this fable are many and have been applied to a variety of areas of my life. It recently popped into my mind again as I was thinking about the needs businesses have today for business continuity planning and disaster recovery contingencies.
Too Much Time Treating Symptoms
A man drives down the highway each day on his way to work. On Monday he gets a flat tire. Like anyone else, he takes his lumps, changes his tire, and moves on.
Sharing the Reins: 10 Reasons To Sell Your Company To Your Employees
In 1987 I sold my business, South Mountain Company, to my employees (and myself). My sole proprietorship became an employee-owned cooperative corporation. It was a hinge point in the history of the company. Ownership has become available to all employees, enabling people to own and guide their workplace. The responsibility, the power, and the profits all belong to the group of owners.
Ten Top Ways for Managers to Motivate Their People
So to help start the ball rolling, here are ten top ways to get your people
motivated. Ten small steps for you to start with.
Innovation Management and Brainstorming Management ? why people hate to brainstorm!
Creativity can be defined as problem identification and idea generation whilst innovation can be defined as idea selection, development and commercialisation.
Stopping The Brain Drain: How To Capture Key Business Knowledge Before It Walks Out The Door
The verdict is in: More and more baby boomers will be leaving the workplace sooner, rather than later. Many industries are predicting that between 25 and 45% of their more senior employees will soon be departing their organizations. And as they leave, they will be taking vast amounts of accumulated business knowledge with them.
Planning a Productive Retreat
What value is there in leadership or team-building retreats? Just consider the following.
Management - Mary Poppins Style!
Mary Poppins describes a style of management which has for too long been hidden in many
businesses and organisations.Think about it.She's "Practically
perfect in every way" - is that not what we want from a boss? Someone who is
almost brilliant at everything - yet with a hint of not being absolutely
perfect? Someone we can trust and depend on - yet who is truly human with is and falls down occasionally too?And then there's
the cut to the chase with, "Bert, what utter nonsense. Why do you always complicate
things that are really quite simple." How often do we, often inadvertently (especially
the more senior an executive we are), make things so, so complex. Recently working
with a client who already had over 125 books on systems, when all they were doing
was selling things to people...And then there's all the fun, like..."Of course,
you can say it backwards, which is dociousaliexpilisticfragicalirupus, but that's
going a bit too far, don't you think?"...a satisfying ability to have fun and, I
think perhaps just a hint of a smile at yourself, Mary, in that..., as Bert says
"Indubitably.!" Not forgetting either, that if we look hard enough, with the right
viewpoint..."In every job that must be done, there is an element
of fun. You find the fun and - SNAP - the job's a game!"
Performance Expectations - 5 Tips and 5 Questions
People want to understand their role - they want to do well! So by being clear, really clear about what it expected of them, makes a big, big difference! And that improves performance as well as saving you time chasing others around to deliver what you want.
3 Tests To Hire The Best
Question: What's the easiest, cheapest and quickest way to have profitable, productive, and honest employees?
Creativity and Innovation Management ? Money Doesnt Do It
Creativity can be defined as problem identification and idea generation whilst innovation can be defined as idea selection, development and commercialisation.
Building Trust in Your Business Relationships - 10 Steps
There are some simple things you can do with your people to ensure that they start to trust you. As a letter from Mike Emmott of the Chartered Institute of Personnel and Development in the UK says, in April 2005's UK Management Today says:-"Our surveys show that only one in four employees trust senior management to look after their interests"Is that not appalling? How on earth can businesses develop, survive and above all hang onto their best people if they are seen to be untrustworthy?It's horrible.There is an article below which talks a little about 'Rapport Building', but to supplement that, here are Ten Steps to help you build trust with your people.
5 Interviewing Mistakes That Can Lead To Hiring The Wrong Person
Mistake #1: Going with the flow
Avoid Outsourcing Pitfalls in the Injection Molds and Stamping Dies Markets
When looking to outsource overseas for Plastic Injection Molds or Stamping Dies there are many things to consider.
Usually price is the first thing to be looked at, that's probably why you're looking overseas for a new mold or die source-to save money.
One of the first places to come to mind is Asia.
Large labour forces and low wages can get your job done quickly and cheaply. Or so you think.
|
