Adding attachments to emails

Hello,

I want to send an automated email including an attachment; the same attachment to be sent to multiple people. One way that I can do is to have that same file in the all the records of the table and refer to them in the Attachments part of the email. But, what I would like to preferably is to be able to have one file somewhere (like in a separate table) stored, and link that single file in the Attachments. Is it possible? This way I don’t need to unnecessarily create an extra column of the same thing.

Thanks
Amir-Homayoun

1 Like

Welcome to the community, @Amir-Homayoun_Javadi! :smiley: It’s definitely possible. I’ve got a base for an online class that I teach, and built an automated messaging system for sharing notes with my students, including the option of sending attachments. I’m glossing over some parts of the system’s design, but in short, each student record gets linked to a message record, and that link triggers the automation in the [Students] table. The student record includes a lookup field to pull in the message’s attachment, and that’s available in the “Send email” action to insert into the Attachments settings for the message. In my case, I’m running the automation once per student, but a variation on this concept could also work with a single automation run that sends to several recipients.

2 Likes

Thanks Justin. I’ll see what I can do to keep it tidy and intuitive. Thanks.

Any chance you would share this framework? I teach some continuing education classes for a local community college and that sounds awesome.

@Joshua_Caldwell Unfortunately it’s not easily shareable in its current state, as it’s pretty closely linked (literally) to several other design elements in the base. I’d be happy to work with you directly to set up something similar, though. If this interests you, message me and we can set up a meeting.

Hey Justin Totally! I am using Airtable in our non-profit to create functioning linked CRMS and content calendars any advice would be greatly appreciated