导出Outlook里的全球通讯录到Excel

 

最近整理硬盘文件，发现一个Outlook里的全球通讯录到Excel的代码，但不知道这个文件是什么时候下的了，谨向原作者致敬。

注意：
1、这个代码是写在Excel的模块里的。
2、通讯录中联系人个数多的话，可能时间有点长

 

Const CdoAddressListGAL = 0 Const CdoUser = 0 Const CdoRemoteUser = 6 #Const EarlyBind = True Sub Approach() 'Requires Excel 2000 as it uses Array 'A reference must be set to the CDO 1.21 Library for Early Binding 'The file is cdo.dll Dim X As Variant, CDOList As Variant, TitleList As Variant, CDOitem As Variant Dim NumX As Long, ArrayDump As Long, i As Long, v As Long, u As Long Range("a1:R1").Value2 = Array("Global Name", "Given Name", "Surname", "Email address", "Logon", "Title Field", "Telephone", "Mobile", "Fax", "CSG/Group", "Department", "Site", "Address", "Location", "State "