![]() If you want to print the name of the person on the first line and then the corresponding address of the person on the second line, you should first click on the “Label” field, then click on the second field, “Merge Fields” and then select the “Name” column. Step 4: Design the labelĬlick on the “Label” field and start entering the data. If you don’t know which label to select, simply choose the 5160 label template and proceed to the next step. You’ll see the label details in the right column after you select the template.Ĭlick on the “Apply template” button to choose the template. You’ll see three fields on this pop-up: Label Template, Merge Field, and Label.Ĭlick on the Label Template field and choose the label template of your choice. 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. Orientation: Print envelopes in portrait or landscape orientation.Labels are an important part of mailing, and they can be tricky to create manually. Include the company name and country or region Print envelopes in alphabetical order or by postal code Print an envelope for a specific address (such as work) or all addresses (for contacts who have multiple addresses) Include your return address (it must appear on your contact card) Label: Choose additional items to include on envelopes. Or for a nonstandard envelope size, choose Define Custom to create and define your own layout. ![]() Layout: Choose a standard envelope size from International, North American, or Japanese layouts. If you don’t see the Style pop-up menu, click Show Details near the bottom-left corner.Ĭlick Layout, Label, or Orientation to customize envelopes. Only contact cards with addresses are printed.Ĭlick the Style pop-up menu, then choose Envelopes. In the Contacts app on your Mac, select one or more contacts, or a list. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |