我正在尝试使用Excel中的数据在Outlook中创建事件。
Dim objOutlook As Object
Dim ObjAppt As Object
Dim objNamespace As Object
Dim objFolder As Object
Dim OpenMAPIFolder As Object
Dim objCalendar As Object
Set objOutlook = CreateObject("Outlook.Application")
Set objNamespace = objOutlook.GetNamespace("MAPI")
Set objFolder = objNamespace.GetDefaultFolder(9).Folders("Calendar")
Set ObjAppt = objFolder.Items.Add 'create task item
With ObjAppt
.Body = Range("A1")
.Start = Range("A17")
.End = Range("B17")
.AllDayEvent = True
.ReminderSet = True
.ReminderMinutesBeforeStart = 1440
.Save
End With
Set ObjAppt = Nothing
Set objFolder = Nothing
Set objNamespace = Nothing
Set objOutlook = Nothing
它显示文件夹名称不正确。
发布于 2020-02-19 05:05:05
要转到默认的日历文件夹,请尝试
objNamespace.GetDefaultFolder(olFolderCalendar)
另请参阅
https://stackoverflow.com/questions/60288095
复制相似问题