We are a charity that supports schools in another country and have a base with records for children who are sponsored by people from the wider community. We want to send details from the individual records to the sponsors. We have done this in the past by downloading and mail merging but this requires the photos of the students to be individually downloaded and pasted. Is anyone aware of a better way to do this?
Hi Roger, may I know if you’ve tried out sending an email via Airtable’s automations?
If you have and faced some issues while doing let me know what those were and perhaps I can help you troubleshoot
I have experimented with sending an email from Airtable and face 2 issues:
This is an example record
And this is the email I receive:
here are the details of your XXXX Scholar.
Sent via Automations on
I really appreciate any help you can offer, thank you.
Yeap this is true. If you’re say, sending these monthly, you could create a checkbox field and just mark them all when you want the emails to be sent out
You’d make an automation that would trigger based off of that checkbox field, send those emails, and then update the record to unmark the checkbox field so that you could mark it again next month
If you’re willing to use Airtable’s default “Insert as List” / “Insert as Grid” options, then you could potentially get something that looks like this:
And here’s how that looks as an action: