Laurence School [Helpdesk]

Address Key Map:
Home Phone = Home Phone
Mobile Phone = Mother Cell Phone
Business Fax = Father Cell Phone
E-mail Address = Mother Email
E-mail 2 Address = Father Email
Job Title = Child name and grade
Name = Full Name (Salutation)
Home Street = Address
Home City = City
Home State = State
Home Postal Code = Zip

Outlook contacts are used by Administrative staff to view all Laurence contacts on their mobile devices. Contacts need to be updated on a monthly basis, right after a Senior Systems Global Promote cycle, and after data entry for the School Directory has concluded.

1. Prepare the spreadsheet with the exported data.
   • Child names must be entered with their grade level in the job title
   • Duplicate entries need to be joined to eliminate multiple contact cards after import - these are created from sibling entries
     
     

     

2. Once the data is prepped it can be exported to CSV.
   • Make sure the file contains the proper headings
     
     

     

3. Import the data in Outlook.
   • Import as CSV and map the fields properly using the above key
   • Test on the Contacts app in iOS
     
     

     
     
     

     
     
     

     
     
     

     
     
     

     
     
     

     
     
     

     
     
     

     
     

4. Copy the resulting contact cards to the public folders.
   • Edit the 'Updated' contact card with the current date