![]() 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 |