How to Make Address Labels From Google Contacts
Google Gmail allows you to add and organize all of your email contacts in one place. Along with the name and email address, you can also add information about your contacts including their mailing addresses. Your can then export your contact list to create and make address labels.
-
1.
Log in to your Gmail account.
-
2.
Click “Contacts” from the left-navigation of the Gmail homepage.
-
3.
Click the “More” button from the center of the page.
-
4.
Click “Export.”
-
5.
Click “All Contacts” under Which Contacts Do You Want to Export and then click “Google CSV” under Which Export Format.
-
6.
Click “Export.”
-
7.
Click “Save File” from the Save dialog box and then click “OK.” The google.csv file is saved to the default save location on your computer.
-
8.
Click “Documents” from the upper left corner of the Gmail page. Google Documents launches.
-
9.
Click the “Upload” button on the right side of the page, and then click “Files.”
-
10.
Click the Google.csv file and then click “Open.” Your Google Contacts open in the Google Spreadsheet program.
-
11.
Click the “Create new” button on the left side of Google Documents and click “From template.”
-
12.
Click “Labels and Business Cards” under Categories from the left navigation.
-
13.
Click “Use this template” next to the label template you wish to use.
-
14.
Copy your contact information from the google.csv file and paste it into the individual label cells in your label template.
Writer Bio
Diana Braun began her writing career as a consultant and technical writer for a software company focusing on how-to, training, white paper, and internal process documentation. After two years, Braun left to pursue her entrepreneurial dreams. Since then, she has launched several startups including a t-shirt business, an online marketing and advertising t-shirt distribution business, and an entertainment site. She currently resides in South Florida.