SugarCRM 6/7 customization to automatically check the Sync to Outlook checkbox for all Contacts and Users in the system. Skips inactive/reserved users (e.g. SNIP User) and any deleted records.

sync_all_to_outlook.sql

delete from contacts_users;

insert into contacts_users
(id,contact_id,user_id,date_modified,deleted)
select UUID(), contacts.id, users.id, now(), 0
from contacts, users
where users.deleted=0 and contacts.deleted=0
and users.status='Active';