Fill the cells under these column headers with your recipients’ mailing information. 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.
0 Comments
Leave a Reply. |