This post is about the Microsoft Exchange GAL, i.e., the global address list. The task is to export the data in the GAL to vCard format.
Microsoft Outlook stores local caches of the GAL in
%userprofile%\Local Settings\Application Data\Microsoft\Outlook, see Administering the offline address book in Outlook. On my computer they look like this
Listing of D:\Users\...\AppData\Local\Microsoft\Outlook\Offline Address Books\...
21.05.2016 20:44 <DIR> .
21.05.2016 20:44 <DIR> ..
21.05.2016 20:44 3.818.260 uanrdex.oab
21.05.2016 20:44 686.956 ubrowse.oab
21.05.2016 20:44 56.310.184 udetails.oab
21.05.2016 20:44 20 updndex.oab
21.05.2016 20:44 1.373.676 urdndex.oab
21.05.2016 20:44 25.915 utmplts.oab
6 Files, 62.215.011 Bytes
In Downloading Binary Data, for example Boost C++ Library I already complained about some company policies regarding the transfer of binary data. If the openssl command is available on the receiving end, then things are pretty straightforard as the aforementioned link shows, in particular you then have Base64 encoding. If that is not the case but you have a C compiler, or at least Excel, then you can work around it.
C program ascii2hex.c converts from arbitrary data to hex, and vice versa. Excel VBA (Visual Basic for Applications) ascii2hex.xls converts from hex to arbitrary data.
To convert from arbitrary data to a hex representation
ascii2hex -h yourBinary outputInHex
Back from hex to ASCII:
ascii2hex -a inHex outputInBinary
Programming in Excel VBA is quite easy. Below are some simple basic concepts to access and change the spreadsheet data.
Worksheets(i) references the i-th sheet, usually they are called Sheet1, Sheet2, Sheet3
Cells(i,j) references i-th row, j-th column, e.g.,
Cells(2,3) is C2
Cells(i,j).Value is the content of the cell
- Continue reading