Apr 06, 2018 05:14 PM
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.
Thanks!
Solved! Go to Solution.
Oct 19, 2018 12:06 PM
Apr 08, 2018 09:36 AM
I think the best way is the Page Designer block, but you need a Pro account to use the blocks. You have discounts for nonprofits: https://airtable.com/shr9DxhP6lU9slZE6
Apr 25, 2018 11:20 AM
I have the same question.
Apr 27, 2018 08:36 AM
So you have the same answer.
Apr 28, 2018 07:15 AM
Wow. What a rude response.
Your line was, “Were you able to solve the problem?”
Apr 28, 2018 07:44 AM
We’re you able to solve the problem?
@Elias_Gomez_Sainz didn’t link to the info on the Page Designer Block, which is here:
https://support.airtable.com/hc/en-us/articles/115013405168-Page-designer-block
I’d say using the “business card” page size is your best bet, and as long as each record (row) has each piece of info that you need to be on the label, you can design the label once and then apply it to all records. And I’m pretty sure they have a “print all records” option too.
So the Page Designer Block really is the best tool for this in Airtable.
Apr 29, 2018 12:22 PM
I don’t like to overwhelm the user with too many information, I prefer to point the user in the right track. If s/he likes the clue I left, it’s pretty easy to find the link or the information needed, even asking again :winking_face: I don’t like neither to give “all done” to the user, they have to understand and work their part.
All dependes on the eye of the reader, anyway your message adds nothing but noise. I reentered the forum after days being sick, and a lot of threads were updated with useless messages.
I don’t understand, the line of who?
Apr 30, 2018 06:08 PM
I would like to communicate with Elias’ & Jeremy’s supervisor’s.
Amy L Martz, JD, MPA, MEd
801.231.0286
Sep 04, 2018 04:25 AM
I’m risking wrath here but I am also trying to print labels and did install the block to try and do it.
Unfortunately the custom size option only allows you to create a size in pixels, not mm which I would need for my labels sheet (Avery standard type). Am I missing something?
Thanks,
Hannah
Oct 19, 2018 11:06 AM
I’m having same issue, and I’ve wasted enough time trying to figure it out in Airtable so I’m downloading as CSV into excel and doing a merge into Word like I would any other mailing list. I love love love Airtable but Page Designer needs serious upgrades. It’s too basic at this point. Looking forward to seeing how Page Designer will change over time.
Oct 19, 2018 12:06 PM
Can’t you do this?
Oct 22, 2018 07:56 PM
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.
Oct 22, 2018 08:45 PM
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:
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.
Mar 05, 2020 03:32 PM
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.
Feb 02, 2021 09:20 PM
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!
Aug 05, 2021 09:34 AM
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?
Oct 06, 2021 07:42 AM
Hi @Carol_Mason, did you set your record size in Settings to the intended label size (e.g. “business card” or custom)?
Mar 07, 2022 10:50 AM
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.
Mar 13, 2022 10:24 AM
This is not working for you?
Mar 24, 2022 01:14 PM
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