Microsoft Office Tips

On this page:

International Symbols

In Word , you can always insert symbols not available on your keyboard using Insert - Symbol but if you regularly use certain characters it is worth learning their keyboard shortcuts. For example:

£ Alt 0163 (hold down the Alt key while you key in the numbers from your keypad - not at the top of your keyboard)
¥ Alt 0165
Alt 0128
á, é, í, ó, ú Ctrl ' a (hold down ctrl and then press ' followed by the letter you want)
à, è, ì, ù Ctrl , a
ä, ë, ï, ö, ü Ctrl : a
â, ê Ctrl ^ a
ç Ctrl " c

If you have a name you type regularly and want to automatically change it to add an accent of some sort.  For example a client called Zoë, you can use autocorrect so whenever you type Zoe followed by a space it will change to Zoë.

  1. Type the word correctly, highlight it and choose edit- copy (or the copy icon or ctrl-c)

  2. Choose Tools - Autocorrect

  3. Type the uncorrected word in the replace box and paste (ctrl-v) the corrected word in the 'with' box

  4. Choose OK

Now when you type the uncorrected word followed by a space it will change automatically to the correct version. You can also do this for other symbols such as the Euro or Pound sign.

Non-breaking Spaces

Puts a space between words but will always keep the words together on the same line. For example: 15 September

To enter a nonbreaking space, just press [Ctrl][Shift][Spacebar]. In contrast to the dots that Word uses to denote normal spaces in Show mode, Word represents a nonbreaking space with a degree symbol.

Setting up Outlook XP Free/Busy times (You need your own website to do this)

Usually, your company needs an Exchange server to schedule meetings and see if the people you want to invite are available. However, you can allow other people to check whether you are free or busy  even if you do not have Exchange. (But you do need your own website).

For example if you wanted to meet with me and see when I am available, you will need to add me to your contacts list. So make a new contact called Roz Beste with the e-mail address test@hkcrystal.com. Then on the next tab (Details) of the contact window at the bottom, you will see a field called 'Internet Free/Busy Address' Write http://www.hkcrystal.com/roz.vfb in that field. Save and close the contact. Now do File - New - Meeting request. In the To: box, write test@hkcrystal.com , for the subject, write 'Just testing' and click on the scheduling tab. You should be able to see when I am available. Now close without sending (unless you really wanted to set up a meeting with me!!)

So how do you publish your free/busy times. In Outlook, go to Tools- Options - Calendar Options - Free/Busy Options - check Publish at my location, and write your website name followed by your name with the extension .vfb. for example http://www.yourdomain.com/yourname.vfb Then click OK, OK, OK. You can test it by choosing Tools - Send/Receive - Free/Busy information.

Well, at least that's how it should work. But due to a bug in Microsoft it doesn't seem to work the first time. So as a workaround, I initially published it to my hard drive - c:\mydocuments\yourname.vfb and uploaded it manually to my website (I used Frontpage but any method you normally use should work). Now that the file is already there, Outlook seems happy to update it.

Another small caveat. When it uploads it, it will ask for your username and password. I set it to remember this information - and it does remember but it still insists I click OK the first time it uploads during an Outlook session. However, on subsequent uploads (if you haven't closed Outlook in the meantime) it doesn't need to ask you again.

So now all you have to do is tell your clients/colleagues/friends how to set up a meeting with you and avoid all those schedule clashes for the future.

By the way another small bug. If your friends are having difficulty getting it to work ask them to try retyping the full name field and the E-mail display  - I think this may be a bug - that retyping these fields make it work.

Junk Mail

It is best to make sure your e-mail address is not listed in plain text on any websites so that it can't be found by the junk mailers - but if you do find yourself being targeted, there are a few ways to make your life easier.

I've cut down the approximately 300 junk mails I used to receive per day. Most of this decrease was from turning off my catch-all account on my domain (I used to receive all e-mails sent to any name at my domain but I don't any more since spammers started choosing names at random to send to domain names) and putting a strong spam filter on my e-mail address.

There are 2 main software solutions to work with spam - one is to get a spam filter on your PC which sorts suspected spam into a different folder so you can check your real e-mail first. Spam Catcher which does a pretty good job.

The other method is to stop the spam before it gets to your PC. Some ISPs (and Web-hosts) offer this service - sometimes for a fee but I prefer a service called Spam Arrest which sends an e-mail to suspect senders and asks them to identify a picture. If the the e-mail is genuine, people can respond and the e-mail will get to you.

However, all junk mail filters make mistakes (sometimes they miss junk but more importantly they put real junk in the junk mail box). So you need to keep checking the junk mail box  when you first start using the software. Read the instructions carefully - getting rid of junk is great - but you don't want to lose any genuine e-mails.

Opening .exe files in Outlook XP

The latest versions of Outlook  include some idiot-proof settings to block access to .exe and other 'potentially dangerous' files. If you keep your anti-virus software updated and need to access file attachments, there is no simple setting to work-around this. However, there is an add-in written by Ken Slovak that you can install which will allow you to change the settings. See http://www.slovaktech.com/
attachmentoptions.htm 
 

After you have installed the add-in:
Open Outlook and look in Tools - Options. There is now an 'Attachment Security Options' page. Move any wanted attachments (or all of them) from Level one to Level Two.  You will now be able to save any attachments on the list to your hard-drive.

More information at www.slipstick.com/outlook/
esecup/getexe.htm