It is now time to select the label template from the extension.įrom the menu, select “Extensions” and then click on the “Foxy Labels” extensions, and finally, on the “Create labels” option. Now that we have the data ready, we have also installed the add-on. It has more than a million users and a rating of 4.9 stars on Google Workplace Marketplace. You’ll have to grant a few permissions to the add-ons for it to work correctly. Select the Foxy Labels add-on from the search results, and finally, click on the “Install” button to install the add-on. In the search bar, type “Foxy Labels” and press enter. To install the add-on, click on the “Extensions” option from the menu at the top of the sheet just below the sheet name.įrom the drop-down menu, select “Add-ons” and then select “Get add-ons”. There are many free add-ons available on Google Workplace Marketplace, but I personally use the Foxy Labels add-on as it is easy to use, has many free templates, and works on both Google Sheets and Google Docs. You’ll also be able to merge the data from the spreadsheets. In this step, you need to install an extension to get the label templates. You can access all your spreadsheets in your Google Drive by going to this link: /spreadsheetsĪfter you have your data ready, you can proceed to the next step. If you have the data in MS Excel, you can upload the file to Google Drive and then open the Excel file in Google Sheets. So I had three columns in my Google Sheets: First name, Second name, and Address. Google Sheets Mail Merge Labelsĭid you know that you can create labels in Google Docs? Read this article: How to Make Labels in Google Docs How to Use Google Sheets to Mail Merge Labels? Step 1: Open Google Sheetsįirst, open Google Sheets and enter all the data you want to print on the labels.įor example, I wanted to print the customer’s name followed by the address. In this article, you’ll learn how to use Google Sheets to mail merge labels. If you have a lot of labels to create, Google Sheets is a great way to automate the process.īy using Google Sheets, you can create labels in a very efficient way and it takes hardly a minute to create the labels. Labels are an important part of mailing, and they can be tricky to create manually.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |