This is not possible with Airtable's native tools, but this is extremely easy to do with Make's CSV tools (along with their email tools & Airtable tools).
If you've never used Make before, there is a bit of a learning curve, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses. There are also many Make experts hanging out there who can answer other Make questions.
Alternatively, if you have a budget for your project and would like to hire an expert Airtable/Make consultant to set all of this up for you, please feel free to contact me through my website: https://www.scottworld.com/