Telnet in Windows 7

Telnet IS available in Windows 7, just not by default.

To enable it:

Start > Control Panel > Programs > Programs and Features > Turn Windows features on or off

Select “Telnet Client” and wait for it to install.  Easy peasy.

 

Posted in Internet, Microsoft Windows, Tips | Tagged | Leave a comment

Overlay Scrollbars in Ubuntu 11.04

I’ve persuaded my son to go over to Ubuntu, and I spent last night setting up his laptop to run Ubuntu 11.04 (with Gnome, rather than Unity).  All pretty smooth and he seems convinced, but I hate the scrollbars in 11.04 (left).  In my view, they are awkward to use and anti-intuitive.  Luckily my son doesn’t like them either…

To remove, enter the following in the terminal (you will also need to enter your password):

$ sudo su echo "export LIBOVERLAY_SCROLLBAR=0" > /etc/X11/Xsession.d/80overlayscrollbar
Posted in Tips, Ubuntu | Leave a comment

Turning off URL Recognition in LibreOffice

I find this a really annoying feature – I rarely want to click through to a website from a document.  Worse, when LibreOffice has converted your typed web address to a hyperlink, you can’t edit it if you’ve made a typo without jumping though hoops.

You can undo an automatic hyperlink by using Ctrl-Z

To turn off:

  • Select Tools > Auto Correct Options
  • Select the ‘Options’ tab
  • Uncheck the box next to “URL recognition”
  • Click “OK”
Posted in LibreOffice, Tips | Leave a comment

Mailmerge in Word / Outlook 2007

I need to send a personalised email to a few hundred contacts contained in an Excel  2007 spreadsheet

The first thing to do is to make sure the spreadsheet is properly divided into fields – that is, each cell needs to contain one item.  For example, if you want to start the email with “Hello John”, it’s no good if your name cell contains the whole name.  For these purposes, my spreadsheet simply has two columns, one containing the firstname and the second containing the email address.

Then:

  • Open Word 2007
  • Type your email
  • Select ‘Mailings’ on the Ribbon tab
  • Select “Start Mail Merge” and then select “Email Messages”
  • Click on “Select Recepients” > “Use Existing List…” and then select your Excel document
  • If you want to edit the recepient list, you can do this by selecting “Edit Recipient List” in the ribbon.
  • You then need to add the fields (eg firstname) to the mail you are writing.  The easiest thing to do here is to place your cursor where you want the field to appear (eg next to “Dear “), select “Insert Merge Field” on the ribbon, and select the field you wish to insert (eg firstname).  using my examples, you should now have “Dear «firstname»”.  When you finish, a new email will be produced for each row in your spreadsheet, with «firstname» replaced by the firstname field in the spreadsheet.
  • You can preview how thing will look by selecting “Preview Results”, and clicking the forward / backward buttons next to this.
  • When you are happy, click “Finish and Merge”,  select the email field, and watch it go.

From the ribbon

Posted in Email, Tips | Leave a comment

The Onion Video Podcast

I’ve just spent about an hour looking for the RSS feed of The Onion Network News video podcast.  For the life of me I couldn’t find it linked from the site anywhere, just loads of links to it in iTunes.

After some creative searches, I found it here:   http://www.theonion.com/feeds/onn/

Posted in Recreation | Leave a comment

Email Templates in MS Outlook 2007

I’ve been working with a client this morning who employs someone to respond to customer emails from their website.  Unfortunately, the email requests are almost always the same thing and require the same answer.  Their poor employee spends his days typing the same email over and over and over…

An autoresponder set up on the mail server would be a good enough answer, but a bit too impersonal, and my client wants each email read and personalised if necessary.  So how about an email template that automatically includes all the basic info, and can be edited as necessary?

To set up the template in MS Outlook 2007:

  • File > New > Mail Message  (or just click the New button)
  • Windows Button > Save as > Save as Type: Outlook Template (*.oft)
  • Give it a name

To send an email based on the template:

  • Tools > Forms > Choose Form… > Look in: > User Templates in File System

Select the template required, and you’re ready to go.  Any changes you make to the message will not be saved to the template, so it’s ready to use over and over again and the employee’s time is freed up to make the tea more often.

Posted in Email, Microsoft Windows, Tips | Tagged , , | Leave a comment

Accessing your home PC from the Internet

When I’m setting up websites for people, I usually develop on my laptop which has a webserver installed.  When I’m happy with the site I upload it to the internet for the world to access.  This speeds up development as I can make changes to files without having to access a remote server, or do the tedious download-edit-upload thing.

Sometimes though, it’s useful for the client to be able to look at the website whilst it’s still on my laptop.  Of course, they could just come over and have a look – but this is the 21st Century, and there’s a much better way of doing it.

dyndns.org allows you to set up a permanent web address which points to your PC.  This can get a bit technical – and I can help you set it up on your PC if so – but here’s how I configured mine:

  • Register at www.dyndns.org
  • Create a new Dynamic DNS Hostname – you need to ‘add to cart’, but the first hostname is free
  • Configure your router. You can usually do this by entering your router IP address into your web browser.  (I can never remember my router IP address, so I use umit network scanner to find it – I must remember to bookmark it this time!).
  • You need to find the DynamicDNS option, which on my router (a BT Home Home) is under the advanced tab and enter the login details
  • You then need to configure port forwarding – on the BT Home Hub, this is under Advanced > Application Sharing  so that Web Server (http) points to your computer.

And that’s it – may sound complicated, but suprisingly easy when you try it, and if you want help, contact me!

Beware though! This can open up your PC to the outsideworld and be a security risk, so do proceed with caution.  I always turn mine off when it’s not in use.

Posted in Internet | Tagged , , | Leave a comment

Installing LAMP on Ubuntu 11.04

It usually takes a bit of messing around to get a Linux / Apache / MySQL / PHP web server up and running and having just bought a new laptop I’ve been putting it off.  I’ve just had a request to get a small site together for someone in under 2 hours so I thought I’d better get a test server running.

Thanks to this handy instructional, it took my about 30 seconds and I should have the new site up and running in no time!  [rolls up sleeves]

Posted in Uncategorized | Leave a comment

Typing the € Character

This came up again today with one of my clients who deals extensively in Euros. Having never worked out how to get the € character out of their keyboard, they’ve all resorted to typing out the word ‘euros’ on their invoices.

So we know it’s there in the number 4 key, but how do we get to it??  The Fn key would be the obvious choice, or maybe even Ctrl or Alt?

It’s actually quite simple.  To type the character in most applications, hold down Ctrl + Alt + 4 at the same time.

Posted in Tips | Tagged , | Leave a comment

Microsoft Windows ‘N’ Editions

A client asked me today what the ‘N’ stands for on some edition of Microsoft Windows 7 (‘N’ Editions actually go right back to XP).

In a nutshell, the ‘N’ stands for ‘Avoid’.

In 2004, the European Commission fined Microsoft nearly €500million for Anti-competitive Practices relating to the bundling of Windows Media Player with the Windows Operating System.  Microsoft could continue to bundle Media Player, but they had to offer a version without it and  these are the ‘N’ editions of Windows.  For the most part, everything else is identical.

Posted in Microsoft Windows | Tagged , , | Leave a comment