Printing Mailing Labels
Click here for a printable copy of these directions with photos
Create Your List
A. Update your Google Address Book or Create a spreadsheet of your contacts on your computer:
Exporting Gmail contacts into CSV file
1. Sign in to Gmail.
2. At the top left, click Gmail > Contacts.
3. Click More > Export… .
4. Choose whether to export all contacts or only one group.
5. Select csv as the format
6. Click Export.
7. Choose Save to Disk and OK.
8. Select a location to save your file, and click OK.
Navigate to Avery.com’s Design & Print
3. When you’re ready to print them and you’ve got your label paper navigate to https://www.avery.com/avery/en_us/Templates-&-Software/Software/Avery-Design–Print-Online.htm
4. You can signup for a new account or sign-in with:
username avery@coldwellhomes.com
password sold1234
5. Enter your label number in the quick search
6. You can then choose a theme or just click on the blank one.
7. Click anywhere in the address box on the right, click IMPORT DATA and START MAIL MERGE.
8. Click BROWSE FOR FILE and locate the contact spreadsheet on your computer.
9. Once it populates you should see your contacts and addresses. Click NEXT
10. Click and Drag the fields over to the right hand column. Add a comma between city and state.
11. Click NEXT and COMPLETE MERGE
Print Your Labels
12. Click PREVIEW and PRINT
13. Click PRINT, PRINT YOURSELF, PRINT NOW and then OPEN
14. If it asks you to save just click DON’T SAVE.
15. Then just click PRINT and your labels should print.