Has anyone successfully imported a scheduled route as
defined in MapPoint into Outlook Calandar? How would this
best be accomplished?

Thanks In Advance!

Erab

I'm not sure how much custom programming this would involve, not having automated Outlook. From my perspective, the MapPoint side would be easy, I'm just not sure how difficult it would be to get it into Outlook, given the slew of Outlook version out there. Are you aiming to do this for just one machine or roll it out to standardized configurations?

Eric

Outlook automation (not Express) is really easy. If you can figure out the mapPoint COM Object model Outlook is just as easy! If I remember rightly the objects you're looking to create are those of olAppointmentItem.

Used the following vbScript on my web page but it can be done a lot neater in VBA or C++ etc.

Sub AddAppt(olApp, olDate)
Dim olApt

Set olApt = olApp.CreateItem(1)
olApt.AllDayEvent = True
olApt.Start = olDate
olApt.Subject = "Bank Holiday"
olApt.ReminderSet = False
olApt.Save
Set olApt = Nothing

End Sub

Sub AddToOutlook()
Dim olApp
Set olApp = CreateObject("Outlook.Application")

AddAppt olApp, NewYearsDay
AddAppt olApp, MayDay
AddAppt olApp, SpringDay
AddAppt olApp, SummerDay
AddAppt olApp, GoodFriday
AddAppt olApp, EasterMonday
AddAppt olApp, XmasDay
AddAppt olApp, BoxingDay

Set olApp = nothing
End Sub