How to link access to outlook for reminders?

[damienwjking]

Hi guys,
I was wondering if anyone knew how to use VBA code to link my access database table of [telephone calls to make] to outlook so that it automaticly create reminders (i.e. from the information in the table).

Any takers

 

[Guest_imported]

You will first need to add the Outlook reference to Access (msoutl.olb)

The reminders object can't be added to directly as it is created from either calendar events or tasks... so in this case I have used tasks as the example..

Function ExampleReminder()

Dim OLApp As Outlook.Application
Dim MyTasks As Outlook.MAPIFolder
Dim TaskItem As Outlook.TaskItem

Set OLApp = New Outlook.Application
Set MyTasks = OLApp.GetNamespace("MAPI&quot.GetDefaultFolder(olFolderTasks)
Set TaskItem = MyTasks.Items.Add

TaskItem.DueDate = "06/01/2002 13:00"
TaskItem.ReminderTime = "04/01/2002 10:00"
TaskItem.Subject = "Complete Reminder Module"
TaskItem.Close olSave

Set TaskItem = Nothing
Set MyTasks = Nothing
Set OLApp = Nothing

End Function