Help

Re: Printing address labels

Solved
Jump to Solution
4615 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Joel_Daniel_Har
4 - Data Explorer
4 - Data Explorer

I run a small non-profit and we use Airtable to track all of our donors/volunteers/etc. I want to do address labels for a mailing. We currently have the columns set up as First Name, Spouse Name, Last Name, Street Address, City, State, Zip.

  1. Is there an easy way to print labels from Airtable?
  2. If the best way is to export, then how do I get around that my columns are too specific (ie I need First, Spouse, Last name to be one line, and City, State, Zip to be one line).

Thanks!

21 Replies 21

Can’t you do this?

Great idea, but unfortunately this doesn’t work with Avery labels, as the margins around each label are not uniform, and you can’t control the individual margins when outputting to print in Airtable.

Wayne_Olson
5 - Automation Enthusiast
5 - Automation Enthusiast

Unfortunately, the only way to get labels from contact data in Airtable is to export a CSV and then load into mail merge (I use the Avery Chrome extension with Google Docs).

One thing I’ve done to handle the issue of mailing to contacts with spouses or significant others, where you would want to address both parties on the label while also avoiding sending two mailpieces to a single household, is this:

  • Create a formula field named “Mail Greeting”
  • Designate one of the contacts as the primary contact by way of a checkbox field
  • Created a linked record field to link each contact to a spouse/significant other, if applicable

The formula for the Mail Greeting field is used to input either a single person’s name, for households where you are addressing just one contact, or both the primary contact and the spouse’s/SO’s name.

Here’s the formula I use:

IF({Spouse / SO} = BLANK(), {Name}, IF(AND({Spouse / SO} != BLANK(), {Primary Contact} = TRUE()), {Name} & " & " & {Spouse / SO}, BLANK()))

For two contact households, the output would be, e.g., John Smith & Jess Smith.

I used a free “mm to pixel” conversion calculator page on the web (Google is your friend) and plugged the measurements into the Page Designer for a 21 up label page. Couple more tweaks with the margins and you’re 98% there…

Additionally I think that this is a needed upgrade to Airtable to have a functional native way to print labels. The workaround is described above do not take into account that one might be printing images as well on a label.

Well … after thinking I had it al worked out I can categorically say that Airtable is a complete waste of time for label printing. Hopeless and useless. Don’t even bother.

FYI for anyone else trying to print directly from Airtable to Avery labels (or other), I used a free mm to pixel converter, played around with the label size (px) on Airtable based on this, and adjusted the record padding (px) and the page margin (px) and managed to make it line up pretty well. Had to waste a few label sheets, but probably only took around 30 mins all up for a satisfactory result. Beats exporting and importing data!

I’m not able to get the records to print in a grid, for this to work. I chose that option when printing, but they came out one per page. Is there another setting somewhere to make this work?

Hi @Carol_Mason, did you set your record size in Settings to the intended label size (e.g. “business card” or custom)?

TheDish_VIP
5 - Automation Enthusiast
5 - Automation Enthusiast

Anybody got any updates here?
I am baffled by the fact that this is so complex. It seems like such a basic functionality, and I’m left once again with the feeling that I have spent copious hours compiling data and preparing it for use, and then completely stumped when trying to actually WORK with that data.

This is not working for you?

Laura_Cota
4 - Data Explorer
4 - Data Explorer

I was looking for the specs to print from Page Designer to Avery Label 5160 (30 per page), and couldn’t find in any chat room or airtable template. After 10 pages of test paper, I got some workable settings. They are not perfect; but thought they might help someone:
Print Settings for Avery Label 5160:

Record Size: 280 x 106

X/Y position: 20 / 20

Font: Inter 14, 1.4 line height

Print from Chrome: Grid, Record padding- 0, page margin 40