i have linked tables in my base for Organizations, Contacts, and Applications. i want to be able to select a set of applications and send them all a letter. the Applications are linked to the Organizations, as are the Contacts.
if i filter for a set of records in Applications, how can i export information from the related records in Organizations and Contacts to get the address, people’s names and titles, and emails to create my excel doc for my mail merge? i can’t be the first person who has wanted this. sorry if it’s obvious, i’m new to this.
ok I had the same problem, I created a grid and filter all the information I needed for the spreadsheet to copy and paste into excel. Once that’s done, I create the mail merge in word and select the information from excel and completed the mail merge.
That should help you a lot.
My problem is how to put the letters back into Airtable. lol I have been looking for a solution but can’t find one. so maybe you can help me on that end.