> 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