Hello @PieterG,
Sorry for the delay in answering but have been testing this on & off between other items since your post.
It appears LO (and the Thunderbird DB connector) only retrieve two tables from Thunderbird. These tables are based upon contents of .mab (Mozilla Address Book) files in Thunderbird. The two files looked at are “abook.mab” (Personal Address Book) and “history.mab” (Collected Addresses). The contents of these create the “AddressBook” and “CollectedAddressBook” tables respectively in Base. Any lists in those files are also transcribed as ‘Views’ in the Base table section.
If you create new address books, they are named “abook-1.mab”, “abook-2.mab” , etc. If you import an address book it is named “impab.mab”. Unfortunately these seem to be ignored through the wizard. Additionally, using a macro to access the DB would not get these files either. Also tried from SqLite (used in Thunderbird) but not success.
Now it seems there are some elaborate ways to still accomplish this but the amount of work needed takes a good deal of time transferring data around from one source to another. There also is no automatic updating so every change would need a new transfer of data. There may (not certain) be a way using macros but would need some time to come up with a solution which is acceptable.
This may be cause for you to file a bug report on Bugzilla as it seems there is none on this subject.
If this answers your question please tick the (upper left area of answer). It helps others to know there was an accepted answer.