Label Instructions
Excel:
1. Find the address’ you need and paste into a new document
2. Ensure that the top column are relevant headings
3. Make sure the columns are separated to with the correct suburb.
- Address (not really even needed)
- Owners name
- Address
- Suburb, state & postcode
(like this)
4. Save into file
Word Document:
1. Click mailings
2. Start mail merge (step by step mail merge)
3. Over to the right a task bar should appear
- select Labels and then at the bottom Next (starting document)
4. Open label options (it should be the same as last time but make sure code the same, check label packet)
5. Next (to recipients)
6. Click Browse
- Find excel document on your computer and open
7. Click okay to the table (might be 2 clicks)
8. Click next (arrange labels)
9. Select “more items”
- Insert name, postal address & postal suburb, state, postcode, then close
- Space it out so each are on a separate line and centre in the middle
10. Click “update all labels” (about half way down the task bar)
11. Click next (preview labels) & make sure layout okay
12. Click next (complete merge)
12. Click “edit individual labels” & then okay
- *This will open up a new word document that you can save if you are sending same labels multiple times, save under appropriate name, or no need to save if 1 off.
13. Print file to correct tray with correct paper.