The following methods are marked to indicate whether they are appropriate for the Personal Address Book (PAB), Contacts folders in the Outlook Address Book (OAB) or Microsoft Exchange Server Global Address List (GAL). In many cases, the techniques used for printing can also be adapted to exporting.
Outlook Contacts Folder
- Use Microsoft Access to link to an Outlook table, and use Access as the report designer. Unfortunately, this method does not support all fields.
- Arrange a Contacts folder view showing the fields you want to print, then print directly from the folder. Disappointing if you want the exact e-mail address, since Microsoft Outlook shows the display name instead.
- Use the Address Book as the data source for a mail merge in Microsoft Word, selecting your Contacts folder. The catalog format works well for the merge document. This method will not print details of distribution lists, though, and you’ll get only the first e-mail address from a contact item. The main advantage of this method is that you do get the actual e-mail address, not just the display name that the Outlook view shows.
- Print each Microsoft Outlook distribution list individually.
- Sue Mosher’s book, Microsoft Outlook Programming – Jumpstart for Administrators, Developers, and Power Users, includes a routine to export an Outlook 2000 distribution list to Excel, where you an save it as .csv file.
- Extract The Members Of An Outlook Distribution List To A Word Document (code sample)
Personal Address Book
- Import a Personal Address Book into an Outlook Contacts folder and print from there. In Outlook 2000, distribution lists import just fine. In earlier versions, each entry in the distribution list imports as a separate contact item.
- Import a Personal Address Book into Microsoft Outlook Express, which has a print function. You won’t get distribution lists, though.
- Use the PAB as the data source for a mail merge in Microsoft Word. The catalog format works well for the merge document. This method will not print details of distribution lists, though.
- Use the Export Client Extension to export distribution lists from a PAB into mail messages.
Global Address List
- To print an Exchange 5.5 distribution list
- Making the Exchange Server GAL Portable
Directory Search is an easy-to-use web application that turns your Active Directory in to a corporate phonebook. The administrator defines which fields are visible and the search criteria that can be used. Features include displaying each user's photo (from the thumbnailPhoto attribute) and exporting search results to CSV or Excel.
Export your Global Address List so you can share it with business partners, clients, and internally. Employees can now easily print a hard copy of the company directory for quick access to phone numbers. Beta.
Run reports on distribution lists, users and more, pulling data from Exchange 5.5, Active Directory, or Exchange 2000/2003/2007. List all distribution lists and their members or just the number of members and present the report in XML, HTM, or Excel format. Free.
IMI GAL Exporter (Also known as IMI Global Address List Extractor) for Microsoft Exchange Server is a small utility for Exchange Admin to export GAL to a few file formats. What is new in this version? Native export to CSV, XML, HTML, SQL, Microsoft Office Excel, Microsoft Access. If you are working with Microsoft Office Outlook 2010 and there is more than one Exchange Server to your MAPI profile you can choose a specific Address list (Exchange Server) for export.
- Printing Custom Outlook Forms and Reports
- OL2000 (CW) How to Export Your Personal Address Book to a Text File
- OL2000 (IMO) How to Export Your Personal Address Book to a Text File
- Creating a list of Users and their e-mail addresses in Exchange 2000
- Creating a list of Users and their e-mail addresses in Exchange 2000 (2)