How can I use a GAL to create a contact list in Microsoft SharePoint 2007? I tried exporting the list to Access first, which worked except for the email addresses. In the email address column there was some sort of exchange directory structure. Is there a way to connect SharePoint directly to a GAL? If not is there a way to export the list in such a way that it can be imported into SharePoint?