Office Tips & Tricks: Bulk adding members to a Yammer g...
Office Tips & Tricks: Bulk adding members to a Yammer group
It’s the beginning of a new term next week and we can see that more and more staff and students are starting to post in Yammer and are creating working groups and module-related Yammer groups.
You can save time and bulk add members to a Yammer group, rather than inviting them individually!
1. Create a CSV file with the email addresses
First you need to create a CSV file listing all email addresses of users that you want to invite to your Yammer group. Please bear in mind that Yammer is internal to NTU, so you should only use staff or students’ NTU emails.
- In a new Excel file create column header and give it a name, for example, e-mail addresses.
- List all email addresses in that column.
- You can use Flash Fill to quickly populate email addresses from user’s first and last names – see one of the earlier posts from Rachel: Office Tips and Tricks: AutoFill and Flash Fill in Excel.
- Save the Excel file in CSV format.
2. Upload the CSV file into a Yammer group
- Logon to Office 365 Go to your Yammer group.
- At top right click the Settings icon.
- Scroll down to the Members section > click Add from Address Book (CSV).
- In the Import from Address Book window click the Choose file button > navigate to the CSV file you created earlier.
- Click the Preview button to check the process.
- Then click the Send invitations button.
NTU staff and students can visit the Office Central learning room to find out more about Yammer. You will need to log in to NOW to view the learning room. (Please note: Office Central is an internal resource only accessible by NTU staff and students).
Did you find this Tip & Trick useful?
Why not let us know using the comments? And feel free to share our post with your colleagues.
About the author
Elena is responsible for design and implementation of development initiatives and learning resources to support NTU staff in their use of university systems. Prior to joining NTU, Elena worked in the British Council supporting bidding for and implementation of international development and scholarship management programmes. She has extensive experience as a Learning and Development consultant, specialising in SAP, business process analysis and managing personal and professional development schemes.