Well I haven't been very good at posting here.  I have a new site that people in New Zealand may be interesting.  Have a look here.  Let me know what you think. 

In the meantime, here's another new product I created at Zazzle:

Wow, have I been neglectful of this blog.  I have moved to another country so am going to make some changes to this site, but I will be back to writing training articles in a few weeks.  In the meantime I have been creating more products at Zazzle.  Here's a sample:

I was asked about this and thought it would made a good addendum to the last two posts. How to you take a shot of what is on a computer screen and how do you edit it? I answered this question a while ago in this post, but you can also edit the screen shot in MS Picture Manager.

Here's how:

Make sure the screen image is as you want it to appear and press the Print Screen (Prt Scr) on your keyboard - usually to the right of the main keyboard and above the insert key.

Go in to MS Picture Manager and choose Paste from the Edit menu. The image will be pasted into whichever location is selected in the Shortcuts panel on the left hand side. To find the pasted image click on the selected folder under Shortcuts and search though the contents to find your screen shot. When you have found it, double-click and the image will come up in the central pane. Now you can edit it as described in this post. Make sure you click on Save to make the edits permanent.

In my last post I introduced you to the editing features of Microsoft's Picture Manager software that comes with Office 2007.

Today we will look at how we can use the programme to organise our pictures and send them to other people.

File management

You can easily do some file management while using this programme. To delete images simply click on the image in the central window, and choose the delete button up in the top toolbar represented by a large cross symbol. You will be asked if you are sure you want to delete the file. Click Yes. The image will now be deleted. To move an image from one folder to another, make sure that you have both folders listed in the shortcut panel on the left. Find the image you want to move, click and drag it over the destination folder on the left and when that folder is highlighted, release the mouse button. A copy of the file is now placed in the destination folder. Check it is there before you go back and delete the original. Another way of moving a file is to right-click over the original, choose cut, move to the destination folder and click on paste. The image will be cut from the original folder and pasted into the destination folder.

Inserting images into emails and documents

Usually in a programme like MS Word, or any of the other office programmes, you can choose Insert-Picture, and file manage to your image in Windows. Another way of inserting images is to have the document open and insert it from Picture Manager. Select the image you want to insert, go to File and choose Send To - Microsoft Office (see right). You should see the open document listed so click on the Send button and it will insert the image where the cursor is placed in the document. Alternatively, when sending to a blank Office document, choose which programme you want to insert the image in, and click on Send (note that if you click on the Options link you will be able to change the size).

You can email your image by going to File-Send To and choosing Email. You will be given the Email Task Pane on the right of the screen. Complete the options and click on Create Message. The selected image should then be inserted into an empty email ready for you to address and send.

If you find these features greyed out it means you didn't select an image to send!

I hope you find that a useful summary of software that you may not have used before. 

I came across the MS Picture Manager recently and was reminded what a useful tool it can be, especially if you don't have access to an image editing programme. The next two posts will take you through some of the handy features.

First we will look at exploring the windows. Below you will see a screen shot of the main window:

The panel on the left hand side is the shortcuts panel. To hide it, click on the Shortcut's button just above it. Click again to get it back. By default you will see the image files saved in your My Pictures folder in My Documents. Your ICT department may have changed the default settings, but this is the standard before any customisation.

If you have a folder of images saved elsewhere you can click on 'Add Picture Shortcut...' , find the folder containing the images and then click on Add. You should see the folder listed in the Picture Shortcuts panel and the contents of the folder displayed in the middle window.

You can change how large the images appear in the central window by using the slider at the bottom right (note this does not change the actual size of the image). You can also change how the images are viewed by clicking on one of the three buttons in the top left corner of the central pane.

Editing an image

Use the shortcut panel to find the folder that contains the image you want to edit, and click on it to show its contents. When you see the desired image double-click on it and it should fill the middle window. You can hide the shortcuts panel if you wish by clicking on the Shortcuts button at the top left.

On the right hand side of the screen you see the task pane. Here I have clicked on the Properties task pane from the drop down arrow at the top of the pane (see left) and you can see the size of the file, where it resides and even what model of camera took the photo!

If you choose the Edit Pictures pane from the drop down, you will see a list of editing tools to change the colour, contrast, cropping, and a few other options that are very useful. Experiment with each one in turn. Move the sliders to see the effects on the image in your main window. When you want to try the next edit option click on Back to Edit Pictures at the bottom of the pane.

Resizing and cropping

Note the difference between cropping and resizing an image. Cropping will slice off the edge of the image that you identify. Move your mouse over the handles around the edge and drag inwards. The shaded area will be cut from the image. To retain all of the image but make it smaller you need to resize. The easiest way to choose the resize option and to insert a percentage less than 100 in the fourth option down. Otherwise, if you know the dimensions you want in pixels you can enter the numbers in the box for custom width x height. The Predefined width and height option offers some standard dimensions which might be useful.

When you have finished making all your changes, click on Save to ensure that the changes are made to the original image.

In the next post I will cover file management and sending images by email, from MS Picture Manager.

In my last post I outlined how to create a list which you can use to mailmerge letters. In this post I go over creating a letter in Word 2007, using mailmerge to insert multiple addresses.  

Open Word and choose the Mailings ribbon.

Click on the button that says Start Mail Merge and select Letters. You are given an empty document.

Click on Select Recipients, and then choose Existing List. Find your Excel spreadsheet and click on Open.

Compose your letter, inserting the merge fields from the list under the button Insert Merge Field. To preview how the fields appear, click on Preview Results. This will preview just one of the records in the letter.

When you have completed your letter you can click on Finish and Merge. I always choose the first option Edit Individual Documents so that I can view and edit before I print. You can also save the letters as evidence that the letters were done, should you need proof in future.

That should save you a bit of time in future.

I was working on a project with an administrator recently which involved mailing out to a long list of contacts. This was the second time that the organisation had mailed this list, but the administrator was typing in the address from scratch again!

My advice would be, if you are going to type the list anyway, you may as well type it up into a sheet of labels in Word, and then you can print it out as often as you like later. This would be my suggestion for someone with limited word processing skills.

For those with more skills, or more willing to learn them, I would suggest typing the list into a spreadsheet, with each line of the address in a new column. Here's an example of the layout:

You can then use this spreadsheet of data to create labels, letters and contact lists. When you need to update the data you only need to update the one Excel file, rather than a number of lists and letters.

Setting up a list in Excel

A spreadsheet has rows across the page, and columns down the page. By creating a list in Excel you are actually creating what is called a database, even though it is in a spreadsheet package. Each address in the row is called a record. Make sure that each separate line of address is in a separate column (this is called a field in database language). It is particularly important to put the postcode or area in a separate column because you can then order your list into geographical areas or postcode areas. While you may not need to have this function right now, you might find in the future that this would be very useful.

Give your list relevant column headings, avoiding spaces. This will ensure that you can mailmerge the list later on. Make the column headings bold so they stand out.

In my next post I will use an Excel list to mailmerge to a letter.

Well it's Friday again and I thought it was time for a bit of humour.  As a cat lover I found this particularly tickled my fancy!!

Most of us stick to the default settings when we use software programmes, but if you want to try a new look, experiment with these three options:

If you want a bit more document space, and less of the screen taken up by toolbars, right click over the top of the toolbar and choose 'Minimize the ribbon'.  Now you will see much more of your document. To open up one of the ribbons just click on its name across the top.  To return to the previous view, right click in the same area and choose 'Minimize the ribbon' again to deselect it.

While you were right-clicking on the toolbars you may have noticed 'Customize Quick Access Toolbar'.  Select this and you will be able to add commonly used buttons to the mini toolbar at the top left hand croner of the screen next to the Office Home button. Once in the customise area simply select the button you want in the left hand life and click on 'Add' to move it to the list on the right.

You may wish to see the whole page on the screen to make reading easier.  When you open a document in Word 2007 for the first time you may have been asked if want to open all documents in this format, and you probably chose no at the time.

To have a look at this view click on the second button in of the five view options in the bottom right hand corner:

Once in screen reading view you can click on the 'View Options' button in the top right hand corner to get a range of choices. Note that you can edit text in this view. Click on Close to return to the previous view.

Enjoy taking the time to explore these features.

Where I work our computer network is being overhauled and so the folders we save our work in are changing.  Each person's My Documents area will become a folder on a shared area, so all members of the team will be able to see the contents.  Managers will have a special private drive for staff sensitive work.

This has been a bit of a shock to people who are not use to it, but I have worked with this system before and found it made team working much easier, and also avoided multiple copies of documents being emailed around the organisation.  Assuming that your company doesn't have a policy against it, you can put your private files in there but everyone with access to the shared group will be able to have a nosey around.

So, once you have calmed down a bit and realised there is nothing you can do about it, how can you manage confidential files?

The most obvious method is to password protect the file.  I gave instructions on how to do that in this post earlier this week.  Make sure you keep the password somewhere safe because if you forget it you will not be able to access the document again. 

Secondly, you could keep a memory stick handy and save all confidential and private files to the stick rather than your My Documents area.  The benefit of this is that the files are portable and easy to take home or to another computer not on your network (or on the internet).

Another option would be to use an online documents handler like Google Docs.  I wrote a post on this here.  The advantage of this is that you can access the files whereever you get internet access.

So don't panic!!!!!!  There are plenty of ways to keep your private work private.