In the “Add-ons” menu select “Labelmaker” > “Create Labels” It’s more or less the same process to create mailing labels from google sheets:ġ. Add merge fields and customize your label in the boxĤ.
The first row must contain column names which will be used as merge fieldsģ. Select the spreadsheet that contains the data to merge. In the “Add-ons” menu select “Labelmaker” > “Create Labels”Ģ. Whether you’re printing address labels for a mailing, shipping addresses for a delivery or making name badges for your next event, Labelmaker helps you generate professional labels within minutes.ġ. Labelmaker is compatible with Avery® Labels, ®, Online Labels® Herma®, and more. Create and print labels from a wide choice of label templates. Labelmaker is the best way to mail merge labels within Google Docs and/or Google Sheets. Please click hereto learn about other features in our software such as a Mail Merge, Sequential Numbering, Adding an Image, etc.★ Choose your label from a wide choice of templates ★ Customize labels with images, fonts and colors ★ Print perfectly aligned labels in minutes ★ Super easy-to-use, you don't need to be computer-savvy! Search articles for additional detailed instructions when using other internet browsers not listed. Make sure to check the Paper Size and the Scale is set to Custom and 100% and then click on Print.We do have articles on additional printing tips from these browsers in our Help Center in needed. When using Microsoft Edge, Firefox, or Safari, choose Download PDF and open from your Downloads folder to open the file using Adobe Acrobat Reader.On the print dialog box - Make sure the Scale is set to Custom and 100% and then click on Print.When using Google Chrome (internet browser) to connect to our site - Click on Open PDFĪ new screen will open (preview.pdf) with a full view of your project - click the printer icon at the top right The Printing Tips page will appear - follow the instructions carefully.Save your project - to your online Avery account or your Computer.Click on the green Get PDF to Print button to the right.Click on the green Print it Yourself button to the right.This will give you a full page view of the project.After the information is typed on the label - Click on Step #4 Preview & Print (top of the screen).To create project with the same information on each label, make sure Edit All is selected on the right sideįor instructions on adding different information onto each label see our article on Edit One / Edit All Printing your Project in Design and Print Online.Make formatting changes to the left of the screen.To format text - (ie: choose font, size, centering options etc.) the words Type your Text need be highlighted blue.To enter Text - (on the left side of the screen) click on the T for text then click on Add Text Box You will see one label on your screen and to the right, you will see a small preview of the entire label sheet called the Navigator. Now you are on Step # 3 Customize screen.On Step #2 Choose Design (there are pre-designed templates / blank templates) - for a blank template click on the green button Select this Design.On the template page that appears, click on the red Start Designing button.Type in the product number (4 or 5 digit code) in the search box in the center of the page and click on the small magnifying glass or press Enter on your keyboard (the Avery product number is located on the front of the package).To create a new project - go to /templates Finding your Avery Template