Import Data into Outlook 2003

[David Kjeldsen]

I am trying to import data from a MS Access database into
Outlook 2003.

When I reach the "Select Destination Folder" using the
Import/Export function, I have no destination folders
listed.

I have tried importing various file types, all "stall" at
the select destination folder.

Any ideas on why this is happening?

 

[deko]

Here's some code I use to export Appointments to Outlook - I have an Access
form where the user fills in date, time, etc...

Private Sub cmdExport_Click()
Dim objOutlook As Outlook.Application
Dim objAppt As Outlook.AppointmentItem
Dim intDuration As Integer
Dim objRecurPattern As Outlook.RecurrencePattern
Dim dtmEnd As Date
Dim dtmStart As Date
Dim varDuration As Variant
Set objOutlook = CreateObject("Outlook.Application")
Set objAppt = objOutlook.CreateItem(olAppointmentItem)
With objAppt
.Start = Me!ApptDate & " " & Me!txtStartTime
.Subject = Me!Subject
.Location = Me!Entity_ID
If Not IsNull(Me!memApptNotes) Then .Body = Me!memApptNotes
If Me!chkAllDayEvent Then
.AllDayEvent = True
.ReminderMinutesBeforeStart = "1080"
Else
dtmEnd = (Me!txtEndDate & " " & Me!txtEndTime)
dtmStart = (Me!ApptDate & " " & Me!txtStartTime)
varDuration = DateDiff("n", dtmStart, dtmEnd)
.ReminderMinutesBeforeStart = "15"
.Duration = varDuration
End If
.ReminderSet = True
.Save
.Close (olSave)
End With
Set objAppt = Nothing
Set objOutlook = Nothing
End Sub