![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Only when i forward emails with attachements "550 relaying mail to" [domain] "is not allowed" | Alchemy | Outlook - General Queries | 4 | March 8th 06 11:47 PM |
"Address list could not be displayed" | Jenn | Outlook - Using Contacts | 2 | February 10th 06 05:38 PM |
Outlook - delete a reoccurring appointment, from "this point on" | haveaniceday | Outlook - Calandaring | 2 | January 17th 06 07:03 PM |
In Table View can I group by "Date" instead of "Start" | KLM | Outlook - Calandaring | 1 | January 11th 06 04:52 AM |