Description: Macro to export Outlook 2010 Contacts from a pst file into a spreadsheet. Macro can be extended to export the contact picture also. Hoped it would work without Excel, i.e. using LibreOffice Calc to open attachment entitled "2016.10.23 Outlook pst to CSV.xls". The default Address Book in Thunderbird does not support categories; hence, the file could then export the information to a CSV file for importing into Thunderbird's CardBook add-on: https://addons.mozilla.org/thunderbird/addon/cardbook/ This is being written on a Linux; however, it was tested on Windows 8.1 with LibreOffice 5.2 Thank you Steps to Reproduce: 1. Open LibreOffice 2. Tools menu --> Options 3. LibreOffice --> Security 4. Macro Security... 5. Medium. 6. OK 7. OK 8. Open attachment: 2016.10.23 Outlook pst to CSV.xls 9. Enable Macros 10. Yes 11. Error appears Actual Results: Error as described in 'Steps to Reproduce'. Expected Results: Outlook tab in spreadsheet to be populated with Contacts based on Settings tab. Reproducible: Always User Profile Reset: No Additional Info: This can help with migrating from Outlook to Thunderbird. Please advise if you require any additional information. Thank you User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0
Created attachment 128201 [details] 2016.10.23 Outlook pst to CSV.xls
I'd think it is extremely safe to say that we will never support this. The macro is obviously extremely tied to Microsoft's internal Outlook API. 'Variables for importing data from Outlook Dim olApp As New Outlook.Application Dim olNS As Outlook.NameSpace Dim olPST As Outlook.MAPIFolder Dim olFolder As Outlook.MAPIFolder Dim olItems As Outlook.Items '------------------------ 'Import data from Outlook '------------------------ Set olNS = olApp.GetNamespace("MAPI") ...