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-content/uploads/2026/03/InterfacingWithTheOutlookCalendar.zip

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-MicrosoftGraph

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/windows/apps/develop/windows-integration/integrate-sharesheet-overview
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/lunchtime-2/2026-04-28/
join us!

Access Lunchtime Playlist on YouTube:
https://www.youtube.com/playlist?list=PLwIULo1M2EWvapx3zAhd3jhX_ITigxM6M

Видео AL: Interfacing with the Outlook Calendar using VBA from Access, with Maria Barnes канала AccessUserGroups.org