AL: Interfacing with the Outlook Calendar using VBA from Access, with Maria Barnes

Maria Barnes shows how to interface with the Outlook calendar from Access using VBA. She covers both the user’s calendar and shared calendars, and includes examples for both Classic and New Outlook. When you create a calendar item, it is an event. Maria's presentation and ACCDB: https://accessusergroups.org/wp-conte... Maria's sample database for interfacing with Outlook -- includes email and contacts as well as calendar -- gets updated as new features are added. https://github.com/mbarnesatbbs/VBA-M... 0:00 Welcome 0:21 Download Maria's presentation and Access ACCDB database 1:05 Types of calendars in Outlook Shared calendars inside and outside your organization Default (under My Calendars in New Outlook) 1:50 Calendars Inside your Organization how to create a new group and add members 3:35 see Calendars 5:01 manually add individual shared calendars 6:37 Calendars Outside your Organization 8:38 Classic Outlook Interfacing with the Outlook Calendar CreateItem Calendar Explorer 10:29 Classic Outlook Calendar view 3 calendars selected 10:48 Calendar Explorer 10:56 Maria's Calendar Explorer for Classic Outlook calendar groupings My Calendars Team Other Shared All Group 11:14 Name of calendar can't change name of default calendar email address of where they came from -- calendar Parent 12:48 Parent calendar 13:05 hardest thing is getting to the current calendar 13:22 Access form to add Outlook Event for Calendar (appt) prompt for Calendar Grouping, Calendar name, Parent. Assume today at 2:00 pm. 12:46 Classic Entry example 15:30 VBA cmdAddClassicEntry_Click 16:29 References -- could set to Microsoft Outlook Object 16:58 Outlook constants for late-binding 17:52 VBA calendar group name, shared folder name create calendar Entry oOutlook.CreateItem(olAppointmentItem) 18:26 fill information using VBA 19:18 CreateObject starts in hidden mode security prompt 20:46 Adrian - visible Maria change VBA if error for GetObject, not in download -- need to add if you want. CreateObject also sets Visible 22:08 Ade, on CreateObject, test to see if it responds normally before set Visible 23:03 add classic entry using Access to a shared Outlook calendar specify Calendar Grouping, and Calendar Name. Skip Parent since name is unique. 23:57 new event appeared on calendar 24:30 VBA GetNamespace GetExplorer GetNavigationModule Items.Add vs CreateItem 30:12 add classic item for My Calendars, Calendar, specify email address for Parent 31:17 step through VBA code 37:20 New OutLook Calendar Grouping Names different Graph.CreateEvent End Points: events calendarGroups calendars an admin table stores connection information for each namespace 41:44 what it looks like online behind scenes, Exchange data stores information 42:27 compare calendar groupings for New and Classic 43:57 Add Entry thru Microsoft Graph using Access form 44:18 VBA 46:05 CreateCalendarEvent procedure handles the response 46:37 Graph.CreateEvent procedure builds information for the web API 47:49 add item to shared calendar 51:29 Graph Authenticator utility for purchase 52:05 Integrate Share options in your Windows app: A comprehensive guide https://learn.microsoft.com/en-us/win... 53:53 Next Zooming in Access 55:42 Peter Bryant about Graph Authenticator utility Maria, I'm doing authentication Next Meeting New Feature! Zooming with Access by Maria Barnes Tuesday April 28, 12 noon central https://accessusergroups.org/calendar... join us! Access Lunchtime Playlist on YouTube:    • Access Lunchtime