Following up Teams webinar with attendance report

I'm trying to find a way to send a follow-up email to attendants of a Teams webinar. I had a look at pulling an attendance report from Graph but that only got me numbers, not emails. So going back to my original plan which is to use the attendance report export which is a CSV. The problem is the data is not in one neat table. It's split into two . Participants from line 13 and then in meeting activities half way down the document.

So I need to isolate the participants data then selectively pick out email addresses from certain columns, discard duplicates and maybe also find out who registered but didn't attend.

I think I need help with the first bit, picking out the participants data. It always seems to start at line 13 so that may be easy. The problem is finding out when it stops before the meeting activities data starts. That data could be anywhere below the participants but the only value in that line is '3. In-Meeting Activities' so maybe when it finds that, delete it and everything after? Not sure, any help is appreciated

Quick Links