Skip to body

ITS Training

Creating Groups for Class Rosters in GroupWise

Want to send an e-mail to your students? No need to type in all of their e-mail addresses every time. You can group them together and save that group to be used over again. This process can only be done with the client version of GroupWise on either the Mac or PC. Using the Mac client does require an extra step.

Please note that these instructions are also available under the Safari Guides link in the Wildcat Connection. Thanks to Dale Lonowski for this tip!

  • Log into the Wildcat connection and then to Safari as usual.

  • Navigate to your class roster.

  • Locate and click on the download to Excel button (see below) .

Download to Excel button

You can log out of the Wildcat connection now as it is no longer needed.

  • Locate the file in your Downloads folder (or wherever you saved the file) and double-click on it to open it.

  • Continue instructions according to platform below.

PC instructions

  • Copy and paste the list of e-mail addresses into the To field of a new GroupWise e-mail, making sure not to include the column header, just the addresses.

You will know the copy and paste was successful if you see each address on its own individual line.

  • Click on the Address button.

The Address Selector window appears and lists your e-mails in the right pane of the window.

  • Click on the Save Group button at the bottom of the window.

  • Note: there is a drop-down arrow on that button that allows you to select which book to save the group in.

The New Group window appears with your e-mails listed.

  • Give your group a name and Save.

Back in the original e-mail message, the individual addresses will still appear. You can continue as you normally would and Send the message. The next time you compose an e-mail however, type in (or select directly from the address book) the group name you created in the steps above.

Mac instructions

The Mac client of GroupWise requires an additional formatting step before you can copy and paste the e-mail addresses.

  • Type in a semi-colon in the column next to the list of e-mails and fill down so there is a semi-colon next to every e-mail address.

  • Merge the two columns together with the Concatenate function. For example, if e-mail addresses are in column E and the semi-colons are in column F, then in column G type in =CONCATENATE(E2, F2) and fill that formula down so all are merged. See example screen below.

Concatenate function

  • Now copy and paste the new list with the semi-colons into the To field of a new GroupWise e-mail. It may take a moment or two for the list to appear.

  • Click on the Address button.

The Address Selector window appears and lists your e-mails in the right pane of the window.

  • Click on the Save Group button at the bottom of the window. Note: there is a drop-down arrow on that button that allows you to select which book to save the group in.

The New Group window appears with your e-mails listed.

  • Give your group a name and Save.

Back in the original e-mail message, the individual addresses will still appear. You can continue as you normally would and Send the message. The next time you compose an e-mail however, type in (or select directly from the address book) the group name you created in the steps above.

[Back to top]

Page last updated 01/10/12. Send questions or comments to training@cwu.edu.