...
=CONCAT(A1,"@student.runshaw.ac.uk")
Once you have the addresses:
...
You can then use Outlook or webmail to create the meeting.
From Outlook:
- Go to your calendar
- Select New Teams Meeting from the menu bar
- Paste the student addresses into Required
- Set the details of the meeting & press Send
From Webmail:
- Go to your calendar
- Select New Event
- Paste the student addresses into Invite Attendees
- Set the details for the meeting
- Switch on the Teams meeting option (highlighted below ) & send
...