https://bugs.documentfoundation.org/show_bug.cgi?id=103456
Bug ID: 103456
Summary: VBA to export Outlook 2010 Contacts to Spreadsheet
using VBA with Windows operating system and Outlook
installed
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
