Simply pick an Avery label template or name badge template, choose your spreadsheet, and select the columns within your spreadsheet to merge. Just use Google Sheets to create a spreadsheet with your address list or the names of attendees for your event, then this content can be inserted and formatted for Avery products by opening the Avery Label Merge add-on in Google Docs. The new Avery Label Merge add-on brings the ease of Avery templates to your Google Docs content. Whether you’re printing address labels for a mailing or making name badges for your next event, Avery and Google Docs make it easy. The free Avery Label Merge add-on lets you format and print a variety of popular Avery labels and name badges, all from within Google Docs. Remember to follow the steps outlined in this article and you’ll be printing your own Avery labels in no time.Avery Teams Up with Google to Create Label Merge Add-On for Google DocsĪvery Products Corporation is pleased to be a part of the launch of add-ons for Google Docs. Whether you’re sending out mailers or organizing files, this add-on can help you get the job done quickly and efficiently. With just a few simple steps, you can create and print out labels for any purpose. Printing Avery labels from Google Sheets is easy when you use the Avery Label Merge add-on. Can I use Avery Label Merge with any printer?Īs long as your printer is connected to your computer and is compatible with Google Sheets, you should be able to use Avery Label Merge. How do I know which Avery label template to use?Ĭheck the packaging of your Avery labels or visit the Avery website to find the right template for your labels. No, Avery Label Merge is only available for Google Sheets. Frequently Asked Questions (FAQs) Can I use Avery Label Merge with other spreadsheet software? You can then adjust the settings to fit your needs, such as selecting the number of copies you want to print and choosing whether to print one label per sheet or multiple labels per sheet. Make sure that your printer is connected and select the correct printer from the list. Click on the “Print” button to open up the print dialog box. Your Labels Finally, it’s time to print your labels. To add an image, click on the “Add-ons” menu and select “Avery Label Merge” and then “Insert Image.” You can then select an image from your Google Drive or upload a new one. Your Labels At this point, you can customize your labels by adding images, changing fonts, and adjusting the layout. Click on the “Start Mail Merge” button and then select “Labels.” Choose the correct Avery label template and then select “Next.” Choose the Google Sheet that you want to merge from and then select the sheet that contains the data that you want to merge. Once you have selected your template, you can begin merging your data into the labels. If you’re not sure which template to use, check the packaging of your Avery labels or visit the Avery website to find the right template for your labels. Click on the “Add-ons” menu and select “Avery Label Merge” and then “Open.” From here, you can select the Avery label template that you want to use. Your Avery Labels With the Avery Label Merge add-on installed, it’s time to set up your labels. When you see the add-on appear, click on the “+ Free” button to install it. To install the add-on, click on the “Add-ons” menu and then select “Get add-ons.” In the search box, type in “Avery Label Merge” and hit enter. This add-on is free to use and will allow you to easily create and print your labels. Merge Add-On The next step is to install the Avery Label Merge add-on for Google Sheets. For example, if you are creating mailing labels, you might have columns for first name, last name, address, city, state, and zip code. Make sure that each column has a header that clearly identifies what information is contained in that column. Add the information that you want to include on your labels into the sheet. To begin, open up Google Sheets and create a new document or open an existing one.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |