Although Contacts have not been included in Biotics 5, the Contacts from your Biotics 4 database are still within the Biotics 5 databse.  Utilize the following query to export the Contacts data from the Query Builder to Excel, for import into Microsoft Outlook.

/* This query returns parsed Contacts information that can then be exported from the Query Builder to Excel
and then imported to Outlook.

Note - this query uses the DEMLIST function - iheref you don't have this function in your database, you can find it here */

SELECT distinct CONTACT.indiv_name, CONTACT.title,
contact_institution.contact_institution_desc,
DELIMLIST('SELECT NAME_ADDR_TXT FROM CONTACT_NAME_ADDR WHERE CONTACT_ID =
' || contact.CONTACT_ID || 'ORDER BY DISPLAY_ORDER', '|') AS ADDRESS,
delimlist('select phone_number from contact_phone where contact_id = ' ||
contact.contact_id ||
'order by display_order', '|') as PHONE, contact.email_addr,
contact.web_site_url
 

FROM CONTACT,contact_phone, contact_institution
 

where contact.contact_id = contact_phone.contact_id and contact.contact_id =
contact_institution.contact_id