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.
