Old Followup: Appointment "duration" not displayed
Jamie Gardiner-Hill wrote:
Importing a table of appointments into Outlook calendar
from MS Access - Import goes fine and I can see all the
data - but Outlook will not display the appointment
duration.
I am importing start date, start time, end date, end
time - these fields map and display correctly once in
Outlook but the Duration field is blank.
I guess it is calculated "on-the-fly" so to speak, as
there doesn't seem to be a duration field for me to
import to.
Any one know how I can force Outlook to re-calculate this
field?
Am working with Office/Outlook 2000.
I didn't see that you ever received an answer to your question, and I
was experiencing the same problem with appointments imported through
Excel (but not the same appointments if imported as CSV after an
export, interesting). I googled before i coded, though, which of
course took more time than the actual code:
Sub updateDuration()
'
' 2006-01-25 !GTr forces AppointmentItems to recalculate
' AppointmentItem.Duration as Long
'
Set Selc = Application.ActiveExplorer.Selection
For Each AppointmentItem In Selc
AppointmentItem.Start = AppointmentItem.Start
AppointmentItem.End = AppointmentItem.End
AppointmentItem.Save
Next
End Sub
lycka till!
gregory trimper
viika
|