This guide covers the process of creating a student email distribution list in Outlook from an exported Process Scheduler request created by GullNet.

Use GullNet to create your Email list

The first step in the process is to get the student e-mail data from GullNet into a file that Outlook can use.

1. Log into GullNet at http://www.salisbury.edu/gullnet
2. Click NavBar > Menu > SU Custom
3. Click Student Records.
4. Click Report.
5. Click Student E-Mail List.
6. Select the Term and the optional parameters. In the example below, all of the prompt boxes are filled, but typically only one or two options are sufficient. Leaving a field blank will select all possible values. You can also select multiple plans or levels in any combination. The Acad Prog will rarely be used, so you should leave that blank.
   
7. Click Run.
8. In the Process Scheduler Request page, change the Type to Web and the Format to CSV in the Process List.
   
9. Click OK.
10. Click on Process Monitor, and then on the Process List page, click Details.
11. Click View Log/Trace on the Process Detail page.
12. In the View Log/Trace window, the first CSV file listed is the file of Outlook email addresses. The second CSV file is a list of bio/demo data and academic statistics for each person.
    
13. Right click the first CSV file listed (the listing of Outlook e-mail addresses) and choose Save Target As…
14. In the Save As window, name the file with a .TXT extension (e.g., BUSN.TXT) and save it to somewhere you will be able to find it, such as the Desktop. Leave Save as type: as Microsoft Excel Worksheet. Click Save.
    
15. Right-click the second CSV (the bio/demo data) and choose Save Target As…
16. In the Save As window, name the file with a .CSV extension (e.g., BUSN.CSV) and save it to somewhere you will be able to find it, such as the Desktop. Leave the Save as type: as Microsoft Excel Worksheet. Click Save.
    

Use Outlook to create the Student Email Distribution List

Now, you’ll want to use the text file you just created to create a distribution list, or Contact Group, in Outlook.

1. Double-click the TXT document you saved from the previous steps.
2. Press CTRL-A on your keyboard to select all of the entries.
3. Press CTRL-C on your keyboard to copy the entries.
4. Open Outlook and click Contacts in the Navigation Bar.
5. In the Home tab choose New Items>More Items, then Contact Group.
   
6. Assign it a name of your choosing in the Name: field.
7. In the Contact Group tab, in the Members group, click Add Members.
8. Choose From Outlook Contacts (it doesn’t matter which you select).
9. In the Members-> field, right-click and choose Paste.
10. Click OK.
11. Click In the Contact Group tab, in the Actions group, click Save & Close.

Related articles

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.