How to Print Avery Mailing Labels from Airtable

You can print Avery mailing labels directly from your Airtable data - no CSV export, no Word mail merge. TypeFlow's print label mode arranges your addresses on Avery-compatible sheets (5160, 5161, 5162) and generates a print-ready PDF.

For all label types, see our complete label printing guide. To compare with Airtable's built-in tools, see Page Designer vs TypeFlow.

What You Need Before Starting

The traditional workflow for Avery mailing labels from Airtable involves exporting a CSV, opening Word or Avery Design & Print, running a mail merge, and hoping the alignment works. With TypeFlow, you skip the export entirely. Your Airtable data goes straight to a print-ready PDF.

• Airtable base with fields for names and addresses.
• A label template - use TypeFlow's HTML/CSS template builder with print label mode to arrange multiple labels per page.
• Avery label sheets - pick your product number (5160, 5161, 5162, or 8160).
• TypeFlow account - free to create at app.typeflow.us.

What Are Avery Mailing Labels

Avery mailing labels are pre-cut adhesive sheets that work with standard home and office printers. Each Avery product has a unique number - like 5160 or 5162 - that defines the exact label size and how many labels fit on one sheet.

The product number matters because software uses it to position your text correctly. When the dimensions match, you get clean prints without wasted sheets or crooked labels.

Avery Mailing Label Templates You Can Use

Picking the right template comes down to how much space each address needs.

Avery 5160 for Standard Address Labels

The most popular template. Thirty labels per sheet, compact size, works for typical 3-4 line addresses. If you mail holiday cards or donor thank-you letters, 5160 handles the job.

Avery 5161 for Wider Address Labels

Same height as 5160, but wider. Twenty labels per sheet. The extra horizontal space helps with longer company names or addresses that run wide.

Avery 5162 for Larger Address Labels

The most room per label - 14 per sheet. Good fit when addresses have five or six lines, or when you want larger, more readable text.

Avery 8160 for Inkjet Printers

Same dimensions as 5160 but made for inkjet printers. Also works with both Letter and A4 paper sizes - helpful if your team spans different countries.

Step 1: Prepare Your Airtable Base for Mailing Labels

Your Airtable base already holds the data. Organize it so each field maps cleanly to your label template.

At minimum:

• Name - recipient's full name or company
• Street Address - house number and street
• City - city or town
• State - state or province abbreviation
• Zip Code - postal code
• Country - optional, for international mailings

Some people store the full address in one field, others split it across multiple fields. Either structure works - you map whatever you have.

Create a filtered view in Airtable that shows only the records you want to print. That way you generate labels for 50 people, not your entire database.

Step 2: Create Your Avery Label Template

TypeFlow's HTML/CSS template builder with print label mode is the right tool here. You design one label, and TypeFlow repeats it across the entire Avery sheet automatically.

How Print Label Mode Works

In the template builder, you design a single address label with your variables:

{{Name}}
{{Street Address}}
{{City}}, {{State}} {{Zip Code}}

Then configure the print label mode grid to match your Avery format:

• Avery 5160: 3 columns x 10 rows
• Avery 5161: 2 columns x 10 rows
• Avery 5162: 2 columns x 7 rows

TypeFlow fills each slot with data from a different Airtable record. You design one label, not 30.

Optional: add a logo or return address as static content in the template. It appears on every label automatically.

Step 3: Connect TypeFlow and Map Your Address Fields

Sign up at app.typeflow.us and connect your Airtable account via OAuth. Select your base and the table with your contacts.

TypeFlow detects the variables in your template and asks you to map each one to an Airtable field:

• {{Name}} -> Name field
• {{Street Address}} -> Street Address field
• {{City}} -> City field
• {{State}} -> State field
• {{Zip Code}} -> Zip Code field

The mapping takes a few minutes. Once done, TypeFlow knows where to pull each piece of data. For details on field mapping, see the documentation.

Step 4: Generate and Print Your Mailing Labels

Two options:

• Button field: Add a button to your Airtable base that generates labels for selected records.
• Bulk generation: Process an entire view at once for larger mailings.

TypeFlow outputs a PDF with your labels arranged on Avery-compatible sheets. Download and print.

Critical print setting: Set scale to 100% and turn off "fit to page" or "shrink to fit." If the printer scales the PDF even slightly, labels won't line up with the pre-cut sections.

Tip: Print a test page on plain paper first. Hold it against your Avery sheet and check that text falls within each label boundary.

Step 5: Automate Mailing Label Generation with Airtable

If you print labels regularly - every time a new donor signs up or an order ships - automation removes the manual work. Deloitte estimates that document automation can reduce processing time by up to 80%.

Airtable automations can trigger TypeFlow based on events:

• A new record is created in your Contacts table.
• A checkbox "Ready to Mail" gets checked.
• A status field changes to "Approved."

Connect the automation to TypeFlow's script action, and labels generate without clicking. The PDF appears in your Airtable record or sends to email.

TypeFlow's built-in email delivery can also send the generated PDF directly to a recipient or to a shared inbox right after generation. On Pro plans and above, emails send from your own Gmail address so they come from your brand.

How to Filter Which Airtable Records Get a Label

Not every record belongs on a label sheet. Some addresses are incomplete, some contacts are inactive.

TypeFlow lets you set display conditions:

• A checkbox field (only records where "Ready to Mail" is checked)
• A status field (only "Active" contacts)
• A date field (only records created this month)

Common Issues and Solutions

Labels Misaligned on the Avery Sheet

Almost always from printer scaling. The PDF is the right size, but the printer shrinks it. Set scale to 100%, disable "fit to page."

Addresses Cut Off or Wrapping

Font size too large for the label dimensions. Reduce font size in your template, or switch to a larger format like 5162.

Wrong Number of Labels per Page

Print label mode grid does not match the Avery format. Verify columns and rows: 3x10 for 5160, 2x10 for 5161, 2x7 for 5162.

Special Characters Not Rendering

Accented characters (e, n, u) displaying as question marks. Ensure Airtable data uses standard UTF-8 encoding.

Start Printing Avery Mailing Labels from Airtable

TypeFlow skips the Word mail merge entirely. Design your label once, connect your Airtable contacts, and print directly on Avery sheets.

Start for Free and print your first batch of mailing labels in minutes.

For more label guides, see How to Print Labels from Airtable, Inventory Labels with Barcodes, Return Labels, Shipping Labels on Thermal Printers, and Page Designer vs TypeFlow.