Your step by step guide to mail merge with the Avery Wizard

Using mail merge and your database, you can personalise your letters, cards, name badges – in fact, any Avery® printable product! It’s quick and easy to do. Here we step you through the process for using the Avery Wizard to mail merge. For ease, we’ll refer to labels here, but you can merge to any of our printable products. Try merging names for invitations, or name tags!

1. Download the Avery Wizard from www.averyproducts.com.au/au/downloads/wizard.html
2. Open Microsoft® Word, and click on the Avery Wizard icon that will now be visible on your Microsoft Word toolbar
3. On the Welcome to the Avery Wizard screen, click on Next
4. On the Select your Avery Product screen, in the Product number or description field, type the software code of your Avery product and click on Search
5. From the product list that appears, click on the relevant item and click on Next
6. On the Options for Entering Information screen, select Merge data from an existing data file and click on Next
7. On the Select a Data File screen, click on the Browse button to navigate to the file you’d like to merge. Once you’ve used the file, it will be visible in Your most recent data files.
8. When the Wizard takes you to the Customize Your Design area, in the Field names area, click on a field you would like on your labels. Click on << Add Field to Layout to add it to the label.
9. Repeat step 8 for each field you would like on the label
10. Use the formatting and image buttons to design your label with fonts, colours, spacing and images
11. When you are finished, click on Next
12. To preview your work, click Print Preview, or click Finish to switch to your completed work

Tips to a great mail out

• It’s usually easier to check your data and make your changes in your original file than to scroll through labels or letters
• Complete as much formatting as possible in the Wizard, rather than in your document. You'll save time making the change once, rather than page by page in Microsoft Word.
• To add graphics to your merge, simply click on the Insert image button in the Wizard. It is much easier to add a graphic once in the Wizard than to each label in Word.
• Mail merge doesn’t just work for names and addresses. Try merging names and company names for name tags!