In a previous post I covered the supported ways to access WorldClient contact data. Now we’ll dig under the hood a little and I’ll show you one method to convert a contact entry directly to a CSV file. The only tools needed are Windows Explorer and Excel 2007.
Open Windows Explorer on the server, browse to the user’s contacts folder:
e.g. C:\MDaemon\USERS\example.com\UserName\Contacts.IMAP
Copy the file AddrBook.mrk to a temporary area, where you can work on this file, then rename this file to AddrBook.xml. You can copy the file to another machine, from this point forward MDaemon isn’t needed.
Start Microsoft Excel 2007.
Select File – Open – browse to the temporary area and choose the AddrBook.xml file.
Leave the option “As an XML table” option selected and click OK, then click OK again.
Excel will now have a new file opened with the following columns: version, encoding, guid, modified, fullName, email
Delete the columns: version, encoding, guid & modified
Keep the columns: fullName & email
You can now copy and paste this data into a CSV format required by your email client address book for importing.
Please note: the above instructions work if using MS-Office Excel 2007, older versions of Excel may not have the required XML importer.