How to use Google Sheets to mail merge labels | blog.gsmart.in

wondering, what is cooking in our minds today? Well, let’s create a mail merge in Google Sheets that allows you to create and print hundreds of address labels through Google Docs.

let’s discover the magic of this plugin.

Reading: Mail merge labels google sheets

Note: Before proceeding to the first step, make sure you’re signed in to your google account. remember, we’ll also need google docs to install a plugin there to do our job.

opens google documents. click “add-ons” in the menu bar and then “get add-ons“.

How to use Google Sheets to mail merge labels | blog.gsmart.in

once you click on “get plugins“, a small popup will appear. type “avery” in the search bar and press enter.

You will see a plugin called “avery label merge“, click the “+ free” button to install it to your google documents.

How to use Google Sheets to mail merge labels | blog.gsmart.in

after clicking the “free” button, another small popup will appear asking you to choose an account, select the desired account there.

How to use Google Sheets to mail merge labels | blog.gsmart.in

After selecting your account, a new page will appear requesting permission to access your account. click allow to complete the installation process.

How to use Google Sheets to mail merge labels | blog.gsmart.in

See also: Watch Mail for Debit Card Stimulus Payment

to verify the installation, click plugins and you will see all the tags are merged there.

How to use Google Sheets to mail merge labels | blog.gsmart.in

now open the google sheet that has all the names and addresses saved.

For this tutorial, we’ve created a new sheet called “addresses” with some names and addresses. don’t forget to label the column headers in the first row.

See Also:  2017 IRS Federal Income Tax Forms and Schedules to File

How to use Google Sheets to mail merge labels | blog.gsmart.in

now open a new google document > plugins > avery tag combination > new combination

How to use Google Sheets to mail merge labels | blog.gsmart.in

now, a small popup will appear, select “address tags“.

How to use Google Sheets to mail merge labels | blog.gsmart.in

here, you need to select the sheet pattern according to your requirements. we will select “10 labels per sheet”.

How to use Google Sheets to mail merge labels | blog.gsmart.in

In this step, select the spreadsheet where all the addresses are saved and you need to merge them.

we will select the spreadsheet called “addresses”.

See also: Gmail VS iCloud: Your Best Options For 2022

How to use Google Sheets to mail merge labels | blog.gsmart.in

in the left sidebar, click first name, lastname and address. all three terms should appear in the box labeled “label or name tag“.

How to use Google Sheets to mail merge labels | blog.gsmart.in

Now, click “merge” at the bottom of the sidebar to start the merging process.

How to use Google Sheets to mail merge labels | blog.gsmart.in

a pop-up will appear with a confirmation message of the created document. click open to see the final sheet.

How to use Google Sheets to mail merge labels | blog.gsmart.in

a new google doc will open with the address labels that are ready to print.

How to use Google Sheets to mail merge labels | blog.gsmart.in

important:

you need to do all this using google chrome.

In this post, we have described how to print address labels using Google Sheets Mail Merge. .

Not only this, mail merge can be used for many other jobs. we will cover them one by one. stay tuned!

See also: How to switch to compact view in gmail

see also:

  • quick mail merge plugin: send emails directly from your google sheet
See Also:  Free things to send your enemies in the mail

Leave a Reply

Your email address will not be published. Required fields are marked *