Advanced Avery Label Formatting
How to have more control over the design of Avery labels?
This article describes the additional label formatting available in Avery Label Merge add-on in Google Docs as compared to Google Sheets, and how to format mailing labels, shipping labels, and return address labels in Google Docs by using images and tables.
Available from the Google Docs Add-on Only
Additional Formatting
The options available to format the Google Sheets label template are limited. The following list describes the additional options available to design mailing labels, shipping labels, and return address labels in the Google Docs label template as compared to the Google Sheets label template:
Additional fonts and text styles.
Superscripts and subscripts can be added to the text.
Options to customize the indentation.
Additional line and paragraph spacing options, including options to customize the spacing.
The background color of the label can be changed to various colors.
The border of the label can be formatted in terms of its color, width, and whether it is a continous line or dashed line.
Boxes can be inserted within the label, and the borders of the boxes can be formatted in terms of their color, width, and whether they are continous lines or dashed lines.
The label can be seperated into parts using horizontal lines.
Tables can be inserted, and there are options to cutomize the tables.
Drawings, various types of emojis, and special characters can be inserted.
Bulleted lists, checklists, and numbered lists can be inserted.
Image Formatting
When inserting images in the Google Docs Label Template Box to format your mailing labels, shipping labels, and return address labels, the style of the Text Wrapping must be set to Inline with text.
This is done by clicking on your image, and then clicking on Image options > Text Wrapping > Inline with text.
WARNING: If any other style of Text Wrapping is selected, the image may not appear in your merged labels.
Table Formatting
The formatting of the Google Sheets label template is limited, compared to the options available to format the Google Docs label template, which make it possible to format mailing labels, shipping labels, and return address labels as needed using Google Docs.
The following formatting was applied in the example below:
A table with two columns and one row was inserted inside the Google Docs Label Template Box.
The borders of the table can be colored white to make them invisible (here the borders were colored gray for visibility purposes).
The text above and below the table was formatted as size 1 text to maximise the surrounding space.
An inline image was inserted in the left-hand column of the table.
*|Merge fields|* were inserted in the right-hand column of the table.
*|Name|* was formatted as size 10 text, bold, and colored blue.
A horizontal line was inserted.
The remaining *|merge fields|* were formatted as size 8 text.
