[AccessD] Picking Alternate Calendar

Rocky Smolin rockysmolin at bchacc.com
Tue Mar 9 11:06:22 CST 2010


Dear List:

I am trying to push dates into an outlook calendar from Access.  The
calendar will be an alternate calendar, not the default. I'd like to hard
code the calendar name but can't figure out the syntax.  So far I'm using
the following code which allows the user to select the calendar to push the
dates into:

Dim objOutlook As Outlook.Application
Dim objAppt As Outlook.AppointmentItem
Dim objRecurPattern As Outlook.RecurrencePattern

Dim nms As Outlook.NameSpace
Dim fld As Outlook.MAPIFolder

Set objOutlook = CreateObject("Outlook.Application")
Set objAppt = objOutlook.CreateItem(olAppointmentItem)

SelectCalendarFolder:
   'Allow user to select Calendar folder
   Set nms = objOutlook.GetNamespace("MAPI")
   Set fld = nms.PickFolder

 

and that works.  But does anyone know the syntax to set fld to a specific
calendar folder?

 

MTAI

 

is

 



More information about the AccessD mailing list