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