Sometimes you find a feature in a product that is just blatantly missing. One of those in Microsoft Word is the ability to update all the fields in the document with the latest value in a field.
I use both the built in fields e.g. Author, Version, Title and custom fields e.g. Project Code. I set the values once in the document properties and then insert the field codes in the document rather than the text. All is well. If you change the value of a field you can press F9 and all of the fields update to the latest value EXCEPT if you have used the fields in the document header or footer, these do not get updated for some reason. I would classify this as a bug, why would I not want all instances of the same field to be in sync throughout my document.
The solution is remarkably simple. Create the following macro:
Sub UpdateAll() Dim oStory As Range Dim oField As Field For Each oStory In ActiveDocument.StoryRanges For Each oField In oStory.Fields oField.Update Next oField Next oStory End Sub
This can be saved in your normal.dot file and will be available in all your word documents.
As I mentioned previously my company has been bought over. One of the immediate changes is that we are now responsible for booking our own travel and accomodation, rather than it being done centrally. Whilst this is a pain if you are busy, you can turn this to your own advantage.
This week i have “earned” £52.46 for doing my job !
I really hate just regurgitating content from other sites but the following article just hit home, summarising what, in my opinion, sets us apart! Read the article here.
VISTA is an acronym for value, integrity, service, trust, and accountability. These qualities are essential to extend beyond a simple provider-consumer relationship and to establish shared-value consulting relationships.
Value is fundamental to a successful consulting relationship. You must know and be able to articulate what value you will provide as a consultant or will expect a consultant to provide for your BI program. To achieve shared-value relationships, the inverse is also important: You must know and be able to articulate what value the consultant expects to receive. When value is described in measurable terms, it becomes possible to discuss and develop a consensus on value expectations.
Integrity is a cornerstone of good consulting practice. The best consultants operate based upon a code of ethics. As a provider of services, be prepared to state your code of ethics. As a consumer, be sure to ask about it. Key ethics considerations include confidentiality and nondisclosure. Also avoid conflict of interest; be (or hire) a consultant who is not influenced or biased by the possibility of work beyond the scope of the current engagement.
Service is the heart of successful consulting; it is a service business. Thus, consultants are service workers. An effective consultant is one who actively works to deliver real benefits to clients in a professional and effective way. A positive and pleasant experience upon conclusion of each engagement is the mark of service-oriented consulting. As a consultant, be able to clearly articulate your service model. If you’re hiring a consultant, be sure to ask how your prospective consultants define and deliver service.
Trust aids in confidence, comfort, and ease of communication – all essential for successful consulting. A relationship based on trust prevents suspicion and misgivings for both providers and consumers of consulting services. Good consultants know how to establish trust and will offer solid and meaningful references who attest to their trustworthiness. Wise consulting clients openly inquire about references and take the time to check them carefully.
Accountability helps to set expectations, enhance communications, prevent misunderstandings, and assure a conflict-free consulting experience for both parties. Before a consulting engagement begins, agree on fees, reimbursable expenses, reporting responsibilities, the form and frequency of progress reports, the basis of billing, and payment terms and conditions.