Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outlook private calendar
Hello,
I have a macro in Excel that generates appointments in Outlook calendar. How do I do the same but with a Personal Outlook calendar? Dim olApp As Outlook.Application Dim olApt As AppointmentItem Set olApp = New Outlook.Application Set olApt = olApp.CreateItem(olAppointmentItem) With olApt ..Start = Date & " " & txbStopUur 'Sheet4.Range("B14").Value ..End = Date & " " & txbStopUur ..Subject = "Stoptijd berekend voor: " & txbStopUur 'Sheet4.Range("G3") + " " + Sheet4.Range("M14").Value ..Body = "Priktijd berekend op " & Date & " om: " & txbStartUur & "u" & txbStartMin & Chr(10) & _ "Berekende stoptijd is : " & txbStopUur ..BusyStatus = olFree ..ReminderMinutesBeforeStart = 15 ..Sensitivity = olPrivate ..Save End With Set olApt = Nothing Set olApp = Nothing MsgBox "Your stop time registration has been sent to Outlook.", , "For Information" End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outlook private calendar
I don't believe you can. I believe you have to copy manually. Switch
to the Category View and manually copy the records over. It may help if you assign a category before importing. Goshute |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel and outlook calendar | Excel Discussion (Misc queries) | |||
Outlook/ calendar | New Users to Excel | |||
how do i export excel calendar info to outlook calendar? | Excel Discussion (Misc queries) | |||
Calling a private sub in Outlook via toolbar button | Excel Programming | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |