• Subject: vba import from SQL data base to Outlook Calendar
  • Author: ottk@bellsouth.net
  • Date: 29 May
  • References:
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
29 Mayvba import from SQL data base to Outlook Calendar.ottk@bellsouth.net
29 May\ Re: vba import from SQL data base to Outlook Calendar.Michael Bauer [MVP - ...
29 May   \ Re: vba import from SQL data base to Outlook Calendar.ottk@bellsouth.net
29 May      \ Re: vba import from SQL data base to Outlook Calendar.Michael Bauer [MVP - ...
All times are in (US) Eastern Daylight Time (GMT -4:00)