![]() ![]() On the first row of your worksheet, type the following column headers:.If you haven’t set up any mailing lists before, here’s how to start one: This makes it more convenient for you to add your merged fields. It’s best to set up your mailing list prior to using Mail Merge for Google Docs. Set Up Your Mailing List on Google Sheets Did you know that you can actually use it to automatically enter your envelope names and addresses from a mailing list? Here’s how. The steps above only allow you to modify the paper size on your Google document. But that isn’t the main feature of Mail Merge. Related: How To Print Labels From Google Sheets 2023 Optional: Use a Mailing List to Auto-Fill Your Envelope Addresses Include your recipient’s name, street address, city, state, and ZIP+4 code. Recipient address: Place this in the center of your envelope on the line below the return address.It consists of your name, street address, city, state, and ZIP+4 code. ![]() Return address: This is printed on the top-left corner of your envelope.In this case, we have formatted our example below according to USPS standards. Pick your preferred size from the drop-down menu under “ Envelope size.” (We’ll use Size 10 in this example, as it’s one of the most commonly used sizes for mailing.)Īt this point, all you need to do is to insert the necessary details on your envelope.Select “ Envelopes” from the Mail Merge selection that appears on a side panel.Related: Mail Merge in Google Sheets: Easy Step-by-Step Guide 2023 Step 3: Select an Envelope Size Using Mail Merge for Google Docs In case its icon doesn’t appear on the sidebar, refresh your current tab.Hit the “ Install” button, then follow the installation instructions to proceed with the add-on.Click on the search bar, type “ Mail merge for Google Docs,” then press “ Enter” or “ Return” on your keyboard.Alternatively, simply hit the “ Get Add-ons” button (denoted by a plus (+) icon) on the sidebar at the right.On the menu bar, click on “ Extensions” > “ Add-ons” > “ Get add-ons.”.To install Mail Merge in Google Docs, simply follow the steps below: If you’re uncomfortable about this, you can download our Google Sheets Envelope Template below. Step 2: Install Mail Merge for Google Docsīefore proceeding below, note that you may have to give access permissions to the add-on for you to use it. Don’t make any changes to your new document yet.Start a new document by clicking on “ Blank.”.Floor the steps below to use it for envelope printing: Step 1: Create a New Document While this method is more commonly used in emails, it also has a Google Docs-compatible version. Then, it automatically retrieves this information and inserts them into your emails. It requires you to create a data source - a spreadsheet - containing the information of your recipients. People often use Mail Merge to personalize their emails, especially when sending them in large batches. Method 1: How to Print Envelopes in Google Docs with Mail Merge Method 3: Google Docs Envelope Template.Method 2: Envelope Printing Using Page Sizer.Set Up Your Mailing List on Google Sheets.Optional: Use a Mailing List to Auto-Fill Your Envelope Addresses.Step 3: Select an Envelope Size Using Mail Merge for Google Docs.Step 2: Install Mail Merge for Google Docs.Method 1: How to Print Envelopes in Google Docs with Mail Merge. ![]()
0 Comments
Leave a Reply. |