View Single Post
  #1  
Old January 25th 06, 10:33 PM posted to microsoft.public.outlook.calendaring
[email protected]
external usenet poster
 
Posts: 1
Default 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

Ads