Exchange Bulk Export / Import Mail Contacts
KB ID 0001349 Problem I had to do this today and realised, it’s been so long since I did it last, I’d forgotten how to do it. Before we go forward, please be clear, I’m talking about MAIL CONTACTS, these are Active Directory Objects that have an Email address, but DO NOT have a mailbox in your Exchange Organisation, and DO NOT have an Active Directory User. I point this out because you can have MAIL USERS that have...
Outlook – The {name} Column is Missing from my Inbox
KB ID 0000198 Problem I don’t know why, but the From column disappeared from the Outlook (2007) Inbox this morning. Should this happen to you, and you need to restore (or add/remove) a column to/from your inbox. Solution 1. Within Outlook > Click View > Current View > Customize Current View. 2. Click Fields > Select From (Or the one you are missing/want). > Add > You can then move it up and down the list. >...
Excel – Creating a Dropdown Box ‘From data on another sheet’
KB ID 0000711 Problem My wife asked me how to do this today. I don’t use Excel much, most people think because I work in IT I know everything about all software packages, and they are surprised when I’m asked questions like this, and I say ‘I don’t know I’m a network engineer’. But seeing as it was for the better half, I fired up Excel and worked it out. (This must be worth at least a cup of Tea!)...