All you need is Excel and Word and some Sticky labels.
Here are instructions with apologies to folks with slightly different versions of Microsoft Office:1. Use Excel to create a Database of Addresses
A ready made sheet called addresses.xls can be downloaded by clicking the link below
- Save it in My Documents
- Open it and Type your addresses in it
2. Use a Word document to design the labels
Depending on your version of Word Click on Tools, Letters and Mailings and Mail-Merge
(Word 2003 will open a side panel on the Right)
4. Select the Fields to Merge
Click the button (in the right hand panel in Word 2003) a box will popup...
Start by selecting Title, then click the Insert button
Now click on Initial then click Insert
LastName then Insert
Address1 then Insert
Address2 then Insert
Town then Insert
County then Insert
PostCode and Insert
and finally Country then Insert
Now close the pop up (with the X top right)
5. Arrange the Merge Fields
Look at the top left of your Word Document you should see a jumble of fields each bracketed in double chevrons
Start by clicking between the Country and Post Code fields (be careful not to delete a field - click undo if you do)
Press Enter to move Country onto a new line. Do the same for other fields and press the spacebar on the keyboard to create spaces between fields that you wish to keep on the same line.
You should end up with something like this...
Now that all the Hard work done
To change the Font you could Select All (Ctrl+A) and then select your preferred font (e.g. Arial size 10, Bold)
6. Update all the labels
Word 2003 makes this a little easier... Just click the button on the right
7. Preview your labels - Click the blue Preview your labels link at the bottom right
|8 Complete the merge|
9. Print the labels
In Word 2003 this is towards the top of the right-hand panel
In older versions of Word you need to select the Merge to Printer button on the mail merge toolbar
(Just clicking Print will only print the current page of labels)
Once setup and saved - your next mail-merge is really simple just open the same Word Document and print the labels.
Some final rules:
Do not modify any text in the Word Document
Only edit addresses in the addresses.xls Excel Workbook
Do Not rename or move the Excel File called Addresses.xls (or it will break the link to your Word labels)
If you want help set it up for you and show you how to use it do not hesitate to contact us