I am working for a lawfirm. The firm uses commercial SQL database app
as calendar. Firm recently bought ten Blackjack phones and wants to
receive calendar on Blackjacks.

I wrote VBA code to get calendar from SQL database and write to
Outlook calendar. The code
works when run on each users machine. I am avoiding any synching
issues by deleting all appointments from Outlook before running
process and bringing current calendar from SQL.

Problem : Where and when to run the code? Attornies want update
automatically at least once a day without having to press button or
run process. I tried running on application startup event of Outlook.
Is this a good idea?

I need a fairly simple solution. I am firms Accountant, Office Manger,
etc. I am fairly conversant with VBA, SQL but have not worked much
with Outlook.

Any ideas will be greatly appreciated