Would you like to...

Print this page

Email this page

Post a comment

Subscribe me

Add to favorites

User Opinions

97% 2% (39 votes)

---

How would you rate this answer?

Helpful

Not helpful Help us improve. Why was this unhelpful?

Thank you for rating this answer.

• Open Excel documents containing contact, such as data imported from Callista
• Open the "Outlook Contact Export Import Template.xls" (LINK at the end of this instructions) as a template that has all the necessary field ranges for MS Outlook contacts
• Copy data from step 1 into "Student Contact Template for MS Outlook.xls" - ensure they are copied into the appropriate fields (columns).
• Save as the "Outlook Contact Export Import Template.xls" that now contains all the data and name it differently such as BIO210.
• In MS OUTLOOK, do:

In Contact View

CREATING A CONTACT SUBFOLDER:

1. Click File
2. Folder
3. New
4. Name it - such as BIO210
5. Select Contact
6. OK

IMPORTING DATA:

1. Click on File
2. Import and Export
3. Import from another program or file
4. Scroll down and select "Microsoft Excel"
5. Click "Browse" and find the "BIO210" (the file created in Step 4 above).
6. Opt "Do not import duplicate items"
7. Select folder to import data into
8. OK

CREATING DISTRIBUTION LIST:

1. Select the Contact Subfolder where distribution list should be placed
2. Click on File
3. New
4. Distribution List
5. Name the Distribution List  - such as BIO210
6. Click on "Select Members..."
7. In Show Names from the:  Select the contact subfolder - e.g. BIO210
8. Highlight (Select) all the required people / students
9. Click on "Member ->"
10. OK
11. Save and Close

TO EMAIL CONTACTS IN DISTRIBUTION LIST:

1. Find the Distribution list created above
2. Hover cursor over it
3. Right click
4. Select "New message to contact"
5. Compose email and send it to all contacts in the distribution list (At present, we can only send to a maximum of 100 people at once).

http://www.its.murdoch.edu.au/services/email/outlook_contact_export_import_template.xls