> 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